本文介绍了一种通过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
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
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
