serializable

session1:
set transaction isolation level read committed;
select * from tony1;
insert into tony1(id)values(4);
commit;
----------------------
session2:
set transaction isolation level serializable;
select * from tony1;--123
delete from tony1 where id=4;
select * from tony1;--123数据不变
update  tony1 set id=5 where id=4;
select * from tony1;--123数据不变
commit;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30201626/viewspace-1813756/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30201626/viewspace-1813756/