Mysql的事务相关的命令

隔离级别查看与设置

命令	描述	示例
SELECT @@transaction_isolation;	查看当前会话隔离级别	SELECT @@transaction_isolation;
SELECT @@global.transaction_isolation;	查看全局隔离级别	SELECT @@global.transaction_isolation;
SET SESSION TRANSACTION ISOLATION LEVEL	设置当前会话隔离级别	SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED;
SET GLOBAL TRANSACTION ISOLATION LEVEL	设置全局隔离级别	SET GLOBAL TRANSACTION ISOLATION LEVEL REPEATABLE READ;
SET TRANSACTION ISOLATION LEVEL	设置下一个事务的隔离级别	SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;

支持的隔离级别参数：

READ UNCOMMITTED    -- 读未提交
READ COMMITTED      -- 读已提交
REPEATABLE READ     -- 可重复读（MySQL默认）
SERIALIZABLE        -- 串行化