MySQL 共享锁和排他锁

1. 共享锁

-- 对表加共享锁
LOCK TABLE product_comment READ;
-- 对表释放共享锁
UNLOCK TABLE;
-- 对数据集加共享锁
SELECT * FROM table_name WHERE ... lock in share mode;

2. 排他锁

-- 对表加排他锁
LOCK TABLE product_comment WRITE;
-- 对表释放排他锁
UNLOCK TABLE;
-- 对数据集加排他锁
SELECT * FROM table_name WHERE ... for update;