mysql删除数据库的重复数据

删除重复数据，保留id最小的

delete people as a from people as a,(select * from people group by peopleId having count(1)>1) as b where a.peopleId=b.peopleId and a.id > b.id;