想要重新设置自增的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
奇了怪了怎么会报错呢,希望大虾们给予帮助!!!
在服务器: 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
奇了怪了怎么会报错呢,希望大虾们给予帮助!!!
大虾,那mysql里我不想用truncate,因为不想清除表里的数据,要重新设置自增的id,怎么操作啊?
'截至2010-04-13 12:01:23 用户结帖率100.00% 总发帖:1 正常结帖:0
当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html