MySql 隔离级别

1.  READ COMMITTED 

   session 1:

   

set session TRANSACTION ISOLATION LEVEL READ COMMITTED
start TRANSACTION;

update account set balance = balance -50;

select * from account;

COMMIT

 

session2 :

set session TRANSACTION ISOLATION level read COMMITTED

start TRANSACTION;
select * from account

COMMIT