共享锁的写法：LOCK IN SHARE MODE
SELECT * FROM TABLE WHERE id > 0 LOCK IN SHARE MODE;
排它锁的写法：FOR UPDATE
SELECT * FROM TABLE WHERE id > 0 FOR UPDATE;
共享锁的写法：LOCK IN SHARE MODE
SELECT * FROM TABLE WHERE id > 0 LOCK IN SHARE MODE;
排它锁的写法：FOR UPDATE
SELECT * FROM TABLE WHERE id > 0 FOR UPDATE;
本文标题：Mysql InnoDB锁 排他锁 共享锁
本文链接：https://www.haomeiwen.com/subject/dokjbctx.html
网友评论