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

Asked 2012-07-24T12:54:10.950

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

mysql sql

Edit Report

1 Answer

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)
);

answered 2012-07-24T12:55:03.413