Blue4meo
09-21-2002, 08:47 PM
Hello all, im going to tell you right off the bat, this isnt really important, I'm just learning mySQL and having some troubles with some test im running. Tell me why I get the error I do below. Thank you very much for your time!
CREATE TABLE Test (
Name VARCHAR(30) NOT NULL,
LastN VARCHAR(30) ,
Phone CHAR(15) NOT NULL,
Login VARCHAR(30) NOT NULL,
Pass VARCHAR(30) NOT NULL,
Member_ID NOT NULL auto_increment,
PRIMARY KEY(Member_ID) )
MySQL said:
You have an error in your SQL syntax near 'NOT NULL auto_increment,
PRIMARY KEY(Member_ID) )' at line 7
CREATE TABLE Test (
Name VARCHAR(30) NOT NULL,
LastN VARCHAR(30) ,
Phone CHAR(15) NOT NULL,
Login VARCHAR(30) NOT NULL,
Pass VARCHAR(30) NOT NULL,
Member_ID NOT NULL auto_increment,
PRIMARY KEY(Member_ID) )
MySQL said:
You have an error in your SQL syntax near 'NOT NULL auto_increment,
PRIMARY KEY(Member_ID) )' at line 7