如何真正来区分一下 不可重复读和幻读

何真幻读复制mysql> SELECT @@SESSION.tx_isolation;  +------------------------+ | @@SESSION.tx_isolation |  +------------------------+ | REPEATABLE-READ        |  +------------------------+ 1 row inset (0.00 sec)  mysql> select * from test_transaction;  +----+-----------+-----+--------+--------------------+ | id | user_name | age | gender | desctiption        |  +----+-----------+-----+--------+--------------------+ |  1 | 金刚狼 | 127 |      1 | 我有一双铁爪 |  |  2 | 钢铁侠 | 120 |      1 | 我有一身铁甲 |  |  3 | 绿巨人 |   0 |      2 | 我有一身肉    |  +----+-----------+-----+--------+--------------------+ 3 rowsinset (0.00 sec)  mysql>   1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.