Mysql InnoDB锁 排他锁 共享锁

共享锁的写法：LOCK IN SHARE MODE
SELECT * FROM TABLE WHERE id > 0 LOCK IN SHARE MODE;

排它锁的写法：FOR UPDATE
SELECT * FROM TABLE WHERE id > 0 FOR UPDATE;