且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

使用 MySQL LEFT JOIN 删除行

更新时间:2022-01-01 21:58:56

您只需指定要在哪些表上应用 DELETE.

You simply need to specify on which tables to apply the DELETE.

仅删除 deadline 行:

DELETE `deadline` FROM `deadline` LEFT JOIN `job` ....

删除deadlinejob行:

DELETE `deadline`, `job` FROM `deadline` LEFT JOIN `job` ....

仅删除 job 行:

DELETE `job` FROM `deadline` LEFT JOIN `job` ....