<pre name="code" class="sql">SELECT @@GLOBAL.tx_isolation, @@tx_isolation;
SESSION A: SESSION B:
set autocommit=0; set autocommit=0;
start transaction;
mysql> select * from t100;
+-----+-------+
| id | value |
+-----+-------+
| 1 | a |
| 100 | a |
| 200 | a |
| 300 | a |
| 400 | a |
| 500 | a |
| 600 | a |
+-----+-------+
insert into t100 values(700,'a');
mysql> select * from t100;
+-----+-------+
| id | value |
+-----+-------+
| 1 | a |
| 100 | a |
| 200 | a |
| 300 | a |
| 400 | a |
| 500 | a |
| 600 | a |
+-----+-------+
7 rows in set (0.00 sec)
commit;
mysql> select * from t100;
+-----+-------+
| id | value |
+-----+-------+
| 1 | a |
| 100 | a |
| 200 | a |
| 300 | a |
| 400 | a |
| 500 | a |
| 600 | a |
+-----+-------+
7 rows in set (0.00 sec)
此时SESSION A看不到SESSION B的插入:
REPEATABLE-READ 预读
最新推荐文章于 2023-07-31 13:27:45 发布