+ 1
creating a sql table with id auto_increment
CREATE TABLE carmodels1 ( id INT(11) NOT NULL AUTO_INCREMENT, _year int(20), make varchar(20), country_of_origin varchar(20), nick_name varchar(30), color varchar(20) ); could someone fix this for me it returns an error saying "Error Code: 1075. Incorrect table definition; there can be only one auto column and it must be defined as a key
2 Answers
+ 2
my guess (and it's a guess) is that id might also have to be declared as primary key.
+ 1
Yes, thanks, I went through it and it is exactly what was missing