updating existing sql database

Question

Hi, I have a problem, I have created a database with 20 tables now I want to add this add id_ INT(11) NOT NULL AUTO_INCREMENT into my existing tables, how do I go about it? can someone help me with the correct syntax, the table name is "carmodels"?

Answer 1

ALTER TABLE carmodels ADD id_ INT(11) PRIMARY KEY AUTO_INCREMENT
make sure there is no any other primary key column.

Answer 2

AJ thanks, but it keeps on returning syntax error