QQ飞车 sql 数据库清理重复数据
–删除背包（Item）表多账户每个账户重复代码（ItemId）的数据
delete from Item
where Item.rowid
not in (
select MAX(Item.rowid)
from Item
group by ItemID,Uin
);
–删除宠物(PetItem)表宠物重复宠物代码（PetID）的数据
SELECT count(1) from PetItem;
delete from PetItem
where PetItem.rowid
not in (
select MAX(PetItem.rowid)
from PetItem
group by PetID
);
SELECT count(1) from PetItem;
没有回复内容