mysql数据库删除重复数据

1.查询出重复数据

select peopleId from people group by peopleId having count(peopleId) > 1;

2.创建临时表(oracle不用)

create table temp as select peopleId from people group by peopleId having count(peopleId) > 1;

3.删除数据

delete from people where peopleId  in (select peopleId from temp);