删除重复数据,保留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;
删除重复数据,保留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;