MySQL DBCC CHECKIDENT语法错误 [英] MySQL DBCC CHECKIDENT syntax error

问题描述

当我尝试执行时，我不断收到以下语法错误，我对此感到困惑:

I'm confused by this syntax error I keep getting when I try to execute:

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) is for SQL Server.

改为使用alter table ... auto_increment. http://dev.mysql.com/doc/refman/5.0 /en/alter-table.html

这篇关于MySQL DBCC CHECKIDENT语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！