MySql 数据去重

1.查出重复数据

SELECT member_email FROM group_member GROUP BY member_email HAVING COUNT(member_email) > 1

2.去除重复数据

delete from group_member
where member_email in
(
select TEMP.member_email from (
    SELECT member_email FROM group_member GROUP BY member_email HAVING COUNT(member_email) > 1
) as temp
)
and id not in
(select temp2.id from(
    select min(id) as id from group_member GROUP BY member_email HAVING COUNT(member_email) > 1
)as temp2
);

转载于:https://my.oschina.net/u/3657235/blog/3099145