注意,经测试,此事务为READ COMMITED,并不是能读读取所有已提交的更改,只是能读取READ COMMITED隔离级别的事务产生的更改。REPEATABLE READ的事务产生的更改还是不可见的!!!
mysql> SET SESSION TRANSACTION ISOLATION LEVEL READ COMMITTED ;
Query OK, 0 rows affected (0.00 sec)
mysql> select @@tx_isolation ;
+----------------+
| @@tx_isolation |
+----------------+
| READ-COMMITTED |
+----------------+
1 row in set (0.00 sec)