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

目 录CONTENT

文章目录

delete

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

评论区