First execute the command and view the configuration, as follows:
show variables like '%increment%';
If:
auto_increment_increment=2
(free learning video tutorial recommendation: mysql video tutorial )
then execute:
set @@global.auto_increment_increment = 1; set @@auto_increment_increment =1;
If:
auto_increment_offset=2
then execute:
set @@global.auto_increment_offset =1; set @@auto_increment_offset =1;
Related article tutorial recommendation: mysql tutorial
The above is the detailed content of mysql implements self-increasing step size adjustment. For more information, please follow other related articles on the PHP Chinese website!
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
