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