1.查询全局变量:
SHOW GLOBAL VARIABLES [LIKE '%search key%'];
2.修改全局变量:
SET GLOBAL auto_increment_increment = 1;
3.刷新即时生效
flush privileges
1.查询全局变量:
SHOW GLOBAL VARIABLES [LIKE '%search key%'];
2.修改全局变量:
SET GLOBAL auto_increment_increment = 1;
3.刷新即时生效
flush privileges
转载于:https://www.cnblogs.com/bingco/p/11381107.html