•
Delete t1,t2 from ti,t2,t3 where ...
•
Delete from table where ...
•
DELETE FROM jkvideo_video WHERE videoId IN
(SELECT * FROM ( SELECT videoId FROM jkvideo_video LEFT JOIN jkvideo_program USING ( programId ) WHERE jkvideo_program.programId IS NULL ) b)
不能在同一表中查询的数据作为同一表的更新数据(mysql)。
DELETE
ag_master.*
FROM
ag_master
INNER JOIN
(
SELECT
part_id
FROM
ag_master
GROUP BY
part_desc
HAVING COUNT(*) > 1000
)AS todelete ON
todelete.part_id = ag_master.part_id
评论区