mysql implements self-increasing step size adjustment

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!