SQL error - Incorrect table definition; there can be only one auto column

Question

What is wrong with this SQL, -> ); ERROR 1075 (42000): Incorrect table definition; there can be only one auto column

SQL

CREATE TABLE TABLENAME12
(
TAB_ID INT NOT NULL AUTO_INCREMENT,

NAME_FIRST NVARCHAR(200),
TYPE NVARCHAR(200)

);

I am using mysql, how can I solve this. I am trying to create a table. and I get this error

Answer 1

You must specify AUTO_INCREMENT column as PRIMARY KEY try:

CREATE TABLE TABLENAME12
(
 TAB_ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
 NAME_FIRST NVARCHAR(200),
 TYPE NVARCHAR(200)
);