[solved] sql error ora-00907 missing right parenthesis create table

sql error ora-00907 missing right parenthesis create table:

I tried to create the table with the below query then I got the above error,

create table EMPLOYEE (id INT NOT NULL auto_increment,mail VARCHAR(20) default NULL,email  VARCHAR(20) default NULL,PRIMARY KEY (id));

 

then I changed the above query like below then the error gone and the table created successfully,

create table EMPLOYEE (id INT NOT NULL,mail VARCHAR(20) default NULL,email  VARCHAR(20) default NULL,PRIMARY KEY (id));

 

Hope it help you….!!!

Leave a Reply