骑蟋蟀的蝈蝈

摘要： --删除表中重复的数据，只留有id最小的记录delete from SiteShopCuswhere mobile in (select mobile from SiteShopCus group by mobile having count(mobile) > 1)and id not in (select min(id) from SiteShopCus group by mobile having count(mobile )>1)--删除表中多余的重复记录（多个字段），只留有rowid最小的记录delete from vitae awhere (a.peopleId,a.s 阅读全文