•
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</code></pre></div></div>
版权归属：
Dettan
许可协议：
本文使用《署名-非商业性使用-相同方式共享 4.0 国际 (CC BY-NC-SA 4.0)》协议授权
- 0
评论区