更新时间:2023-02-03 08:20:40
请运行以下查询.
SELECT @@auto_increment_increment
如果值大于 1,则通过以下查询将其设置为 1
:
If the value is more than 1 then set it to 1
by the following query:
SET @@auto_increment_increment=1;
注意:此更改仅对当前连接可见.
Note: This change is visible for the current connection only.
为了全局设置它以便其他连接也可以看到您需要为全局和会话设置它的更改.
In order to set it globally so that other connections can also see the change you need to set it for global and session too.
SET @@GLOBAL.auto_increment_increment = 1;
SET @@SESSION.auto_increment_increment = 1;
因此其他连接现在可以看到此更改.
So other connections can see this change now.
更多:
如果您重新启动 MySQL
服务器,此值将被重置.为了使此更改永久化,您需要在 my.cnf [for linux]
或 my.ini [forwindows]
文件.
This value will be reset if you restart your MySQL
server. In order to make this change permanent you need to write this variable under [mysqld]
secion in your my.cnf [for linux]
or my.ini [for windows]
file.
[mysqld]
auto-increment-increment = 1