mysql 单表多条件删除重复数据

2019独角兽企业重金招聘Python工程师标准>>>

DELETE p1

FROM

performance AS p1

LEFT JOIN (

SELECT

performance_id,

fee_id,

user_name

FROM

performance

GROUP BY

USER_NAME,

fee_id

HAVING

COUNT(fee_id) > 1

) AS p2 ON p1.user_name = p2.user_name

AND p1.FEE_ID = p2.fee_id

WHERE

p1.performance_id > p2.performance_id;

 

 

删除之后，可以添加唯一索引或者主键。

 

转载于:https://my.oschina.net/u/2344371/blog/1505241