侧边栏壁纸
  • 累计撰写 781 篇文章
  • 累计创建 1 个标签
  • 累计收到 1 条评论
标签搜索

delete

Dettan
2021-07-10 / 0 评论 / 0 点赞 / 111 阅读 / 461 字
温馨提示:
本文最后更新于 2022-04-28,若内容或图片失效,请留言反馈。部分素材来自网络,若不小心影响到您的利益,请联系我们删除。
/ DATA / delete

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>
0

评论区