MySQL query record

最新推荐文章于 2024-09-21 07:35:03 发布

原创最新推荐文章于 2024-09-21 07:35:03 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

Mysql 专栏收录该内容

2 篇文章

订阅专栏

本文介绍了一种通过SQL语句批量删除特定分组下多个表中记录的方法。这些表包括视图历史记录、域名历史记录等，所有操作均针对指定的分组ID进行。

delete from tb_view_history h inner join tb_domain d where d.id=h.domain_id and d.group_id=$GROUP_ID

delete h from tb_view_history h inner join tb_domain d where d.id=h.domain_id and d.group_id=$GROUP_ID
delete h from tb_view h inner join tb_domain d where d.id=h.domain_id and d.group_id=$GROUP_ID
delete h from tb_domain_history h inner join tb_domain d where d.id=h.domain_id and d.group_id=$GROUP_ID
delete from tb_domain where group_id=$GROUP_ID
DELETE ETCD