SELECT foo.a, bar.a
FROM foo AS foo
LEFT JOIN bar AS bar ON foo.a = bar.a
WHERE foo.a = '123'
FOR UPDATE;
SQL跨表加行级读锁(共享锁)
最新推荐文章于 2023-02-23 21:57:09 发布
SELECT foo.a, bar.a
FROM foo AS foo
LEFT JOIN bar AS bar ON foo.a = bar.a
WHERE foo.a = '123'
FOR UPDATE;