测试Mysql 事务隔离级别

建立表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;