首页 > > 网络编程 > Mysql >

MySQL 事务锁 in share mode

2018-06-18 00:03:38来源：未知阅读 ()

MySQL In share mode 事务锁是比较常用的共享锁

select ... from lock in share mode; 生成表级共享锁，允许其它线程读取数据但不能修改数据。

--First thread
mysql> select * from test lock in share mode;
+------+------+
| id   | name |
+------+------+
|    1 | fee  |
+------+------+
1 row in set (0.00 sec)

--Second thread
mysql> update test where id = 1;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where id = 1' at line 1
mysql> update test set id = 2  where id = 1;
ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction

标签：

版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com
特别注意：本站所有转载文章言论不代表本站观点，本站所提供的摄影照片，插画，设计作品，如需使用，请与原作者联系，版权归原作者所有