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;
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博客 ” ，链接：https://blog.itpub.net/30201626/viewspace-1813756/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
查看事务隔离级别
下一篇：
修改service_name
请登录后发表评论
登录
全部评论
