mysql 5.5 怎么使用事务_mysql 5.5 lock tables与隐式事务提交commit

结论:lock tables可以隐式提交其它会话的未提交事务

测试明细:

----session 1

mysql> start transaction;

Query OK, 0 rows affected (0.00 sec)

mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| performance_schema |

| test               |

+--------------------+

4 rows in set (0.00 sec)

mysql> use test;

Database changed

mysql> create table t_commit(a int);

Query OK, 0 rows affected (0.04 sec)

---session 2

mysql> select count(*) from test.t_commit;

+----------+

| count(*) |

+----------+

|        0 |

+----------+

1 row in set (0.01 sec)

---session 1

mysql> insert into t_commit values(1);

Query OK, 1 row affected (0.01 sec)

---session 2

mysql> lock tables test.t_commit read local;

Query OK, 0 rows affected (0.00 sec)

mysql> select count(*) from test.t_commit;

+----------+

| count(*) |

+----------+

|        1 |

+----------+

1 row in set (0.00 sec)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9240380/viewspace-2149664/，如需转载，请注明出处，否则将追究法律责任。