dbcc checkident(表名,reseed,新值),报错问题,急。。。
想要重新设置自增的id号,
在服务器: localhost 数据库: collect_db 执行一个简单的sql语句:
DBCC CHECKIDENT ('nesky_addonarticle',RESEED,351)
执行不了,下面是mysql返回的报错信息:
#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 ('nesky_addonarticle',RESEED,351)' at line 1
奇了怪了怎么会报错呢,希望大虾们给予帮助!!!
------解决方案--------------------
alter table nesky_addonarticle AUTO_INCREMENT=10;
MySQL官方文档 http://dev.mysql.com/doc/refman/5.1/zh/index.html