建立表abc,字段a
事务一、
-- set session transaction isolation level READ UNCOMMITTED;
-- set session transaction isolation level READ COMMITTED;set session transaction isolation level REPEATABLE READ;
-- set session transaction isolation level SERIALIZABLE;
start TRANSACTION;
update abc set a=2;
select a from abc;
commit ;
事务二、
-- set session transaction isolation level READ UNCOMMITTED;
-- set session transaction isolation level READ COMMITTED;
set session transaction isolation level REPEATABLE READ;
-- set session transaction isolation level SERIALIZABLE;
start TRANSACTION;
select a from abc;
commit;