mysql 实现删除姓名重复的记录

1.create table tmp select min(ID) as autoID from tableName group by Name;

2.create table tmp2 select tableName.* from tableName,tmp where tableName.autoID = tmp.autoID;

3.drop table tableName;

4.rename table tmp2 to tableName;

5.drop table tmp;

上面的那个ID是个自增长索引列，tableName 是你要删除重复记录的表，tmp和tmp2是临时存放数据的表

转载于:https://my.oschina.net/wangwang110/blog/13031