gpt4 book ai didi

MySQL DBCC CHECKIDENT语法错误

转载 作者:行者123 更新时间:2023-11-29 05:40:48 25 4
gpt4 key购买 nike

当我尝试执行时,我对这个语法错误感到困惑:

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

结果是这样的 enter image description here

最佳答案

DBCC CHECKIDENT('table', RESEED, 1) 适用于 SQL Server。

改用alter table ... auto_incrementhttp://dev.mysql.com/doc/refman/5.0/en/alter-table.html

关于MySQL DBCC CHECKIDENT语法错误,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/6963363/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com