MYSQL 自动增加错了,该怎么解决

MYSQL 自动增加错了

mysql> create table c(id int primary key identity(1,1));

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that

corresponds to your MySQL server version for the right syntax to use near ‘ident

ity(1,1))’ at line 1

create table c(id int primary key identity(1,1)); 哪里写错了？ 

谢谢大家帮忙

MySQL 中没有 identity(1,1));

是auto_increment

SQL code

create table c(id int primary key auto_increment);