【MySQL】自增步长调整

佚名 5年前 (2019-10-17) Mysql 1425人围观抢沙发百度已收录

查看配置

show variables like '%increment%';

如果：

auto_increment_increment=2

执行：
set @@global.auto_increment_increment = 1; 
set @@auto_increment_increment =1;

如果：

auto_increment_offset=2

执行：

set @@global.auto_increment_offset =1;
set @@auto_increment_offset =1;
————————————————
版权声明：本文为CSDN博主「qq_33508876」的原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/qq_33508876/article/details/79725543

mysql> show variables like '%increment%';
+-----------------------------+-------+
| Variable_name               | Value |
+-----------------------------+-------+
| auto_increment_increment    | 2     |
| auto_increment_offset       | 1     |
| div_precision_increment     | 4     |
| innodb_autoextend_increment | 64    |
+-----------------------------+-------+
4 rows in set (0.03 sec)

mysql> set @@global.auto_increment_increment = 1;
Query OK, 0 rows affected (0.00 sec)

mysql> show variables like '%increment%';
+-----------------------------+-------+
| Variable_name               | Value |
+-----------------------------+-------+
| auto_increment_increment    | 2     |
| auto_increment_offset       | 1     |
| div_precision_increment     | 4     |
| innodb_autoextend_increment | 64    |
+-----------------------------+-------+
4 rows in set (0.07 sec)

mysql> set @@auto_increment_increment =1;
Query OK, 0 rows affected (0.00 sec)

mysql> 
mysql> show variables like '%increment%';
+-----------------------------+-------+
| Variable_name               | Value |
+-----------------------------+-------+
| auto_increment_increment    | 1     |
| auto_increment_offset       | 1     |
| div_precision_increment     | 4     |
| innodb_autoextend_increment | 64    |
+-----------------------------+-------+
4 rows in set (0.04 sec)