mysql怎么查询、删除重复记录？

1.查询重复记录
mysql> select * from user where name in (select name from user group by name hav
ing count(name)>1);

2.删除重复记录
mysql> delete from user where id not in (select min(id) from user group by name);会报错



实战:
SELECT *
FROM w_member
WHERE Ghid
IN ( SELECT Ghid

FROM w_member
GROUP BY Ghid
HAVING count ( Ghid ) > 1

)

 
delete from w_member where id not in (select min(id) from w_member group by Ghid);