creating a sql table with id auto_increment

Question

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

Answer 1

my guess (and it's a guess) is that id might also have to be declared as primary key.

Answer 2

Yes, thanks, I went through it and it is exactly what was missing