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