MySQL的事务

MySQL的事务 可重复读

mysql>  show variables like 'transaction_isolation';
+-----------------------+-----------------+
| Variable_name         | Value           |
+-----------------------+-----------------+
| transaction_isolation | REPEATABLE-READ |
+-----------------------+-----------------+

mysql>  create table my_table(id int, c int) engine=InnoDB;
Query OK, 0 rows affected (0.02 sec)
mysql>
mysql>
mysql>
mysql>
mysql> insert into my_table values(1, 100);
Query OK, 1 row affected (0.02 sec)