mysql会话变量与全局变量

show session variables;查看会话变量

show session variables like "%log";模糊查询

set autocommit ='off';（同等 set @@session.autocommit ='off'; ）更改autocommit为off 

select @@session.autocommit 查看指定变量(autocommit)

show global variables;查看全局变量

set global  autocommit ='off';同等 set @@global.autocommit ='off'; ）更改autocommit为off 

select @@global.autocommit 查看指定变量(autocommit)