- 事务1:
- set session transaction isolation level read uncommitted;
- select @@global.tx_isolation, @@session.tx_isolation;
- A1.start transaction;
- A2.select * from test.user;
- A3.commit;
- 事务2:
- select @@global.tx_isolation, @@session.tx_isolation;
- B1.start transaction;
- B2.select * from test.user;
- B3.insert into test.user values(5, 'five','xx');
- B4.commit;
- B5.rollback;
- --该片段来自于http://www.codesnippet.cn/detail/0808201614929.html
来源: http://www.codesnippet.cn/detail/0808201614929.html