LOCK in SHARE mode ; -- 存在 ,成功
-- session2
BEGIN;
SELECT * FROM t WHERE c=10 for UPDATE ; -- 失败,阻塞...但,它们之间是不冲突的。
间隙锁和行锁合称 next-key lock,每个 next-key lock 是前开后闭区间。...`t`(`id`, `c`, `d`) VALUES (6, 10, 10); -- 失败
INSERT INTO `cbank`....`t`(`id`, `c`, `d`) VALUES (3, 11, 11); -- 失败
INSERT INTO `cbank`....`t`(`id`, `c`, `d`) VALUES (11, 19, 19); -- 失败
INSERT INTO `cbank`.