您只需要指定要在哪些表上应用
DELETe。
仅删除
deadline行:
DELETE `deadline` FROM `deadline` LEFT JOIN `job` ....
删除
deadline和
job行:
DELETe `deadline`, `job` FROM `deadline` LEFT JOIN `job` ....
仅删除
job行:
DELETe `job` FROM `deadline` LEFT JOIN `job` ....

您只需要指定要在哪些表上应用
DELETe。
仅删除
deadline行:
DELETE `deadline` FROM `deadline` LEFT JOIN `job` ....
删除
deadline和
job行:
DELETe `deadline`, `job` FROM `deadline` LEFT JOIN `job` ....
仅删除
job行:
DELETe `job` FROM `deadline` LEFT JOIN `job` ....