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