REPEATABLE-READ 预读

来源：互联网发布：淘宝里的极有家是什么编辑：程序博客网时间：2024/05/20 16:42

<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的插入:

0 0