mysql删除重复数据

来源:互联网 发布:淘宝怎么设置不包邮 编辑:程序博客网 时间:2024/05/22 11:52
delete from lptemporary 
where docid in (select tt.docid from ( (select docid from lptemporary group by 重复字段 having count(*) > 1) ) tt)
0 0