当我尝试执行时,我不断收到以下语法错误,我对此感到困惑:
DBCC CHECKIDENT('database', RESEED, 1)
在 PHPMyAdmin中…
错误:
#1064 - 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 'DBCC CHECKIDENT('database', RESEED, 1)' at line 1
结果看起来像这样
DBCC CHECKIDENT('table', RESEED, 1) 适用于SQL Server。
DBCC CHECKIDENT('table', RESEED, 1)
使用alter table ... auto_increment代替。http://dev.mysql.com/doc/refman/5.0/en/alter- table.html
alter table ... auto_increment