步骤一:查询出指定字段重复的数据 select id, name, count(id) from table group by name having count(id) > 1; 步骤二:删除指定字段重复的数据 delete from