alter table [checks] add checkid int identity(1,1) not null
mysql> alter table checks add checkid int 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不行啊,出现错误啊
楼主去看看MYSQL的写法吧!加个自增列的语法。
--MYSQL的这么写alter table checks add checkid int unsigned not null auto_increment;
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不行啊,出现错误啊