– 查看mysql数据库得隔离级别
SELECT @@GLOBAL.tx_isolation, @@tx_isolation;
– 修改当前域数据库得隔离级别
– 可以读到未提交得数据
SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
数据库开启事务:
START TRANSACTION;
SELECT * FROM t_user;
SELECT * FROM t_user where username = ‘SuperMan’;
COMMIT;