记录一个删除数据库重复数据的方法

-- 查询存在重复的数据
select * from table_name as a where a.repeat_column in (select repeat_column from table_name group by repeat_column having count(*) > 1) order by repeat_column;

-- 删除重复的数据
delete a.* from table_name as a where a.id != (select min(b.id) from (select * from table_name ) as b where a.repeat_column = b.repeat_column );

说明:删除重复的数据,保留id最小的那条.

(1) 把table_name换成需要处理的数据库表名;
(2) 把repeat_column换成存在重复数据的字段名.