TLDR: While trying to delete a row by primary key on a "child" table that contains a foreign key to another "parent" table, it locks the parent table for the duration of the child's transaction. What could be done with the foreign key / child delete to prevent that lock from happening? While trying to delete a row by primary k
阅读背景：
SQL在删除子表行时锁定父表
来源：互联网
分享到：
