mysql不支持在同一个表查询之后，做修改、删除操作。

删除的思路是，

1、select id from tbl_vod group by d_name having count(d_name)>1 找到需要保留的id

2、 select id from (select id from tbl_vod group by d_name having count(d_name)>1） as a 把需要保留的结果指定新的表名，找到保留id

3、执行删除操作

delete from tbl_vod where id not in (select id from (select id from tbl_vod group by d_name having count(d_name)>1） as a)

打赏

微信扫一扫，打赏作者吧～

本文固定链接: https://www.cxy163.net/archives/843 | 绝缘体