删除特定条件下的iOS应用信息
本文介绍如何通过SQL查询删除iOS应用信息表中特定条件下的数据，具体为删除设备令牌重复超过一定数量的应用信息。
delete from mgo_iosapp_info
where id not in (
select id from (
select MAX(id) as id ,count(deviceToken) as count from mgo_iosapp_info GROUP BY deviceToken HAVING count >0) as tab)
where id not in (
select id from (
select MAX(id) as id ,count(deviceToken) as count from mgo_iosapp_info GROUP BY deviceToken HAVING count >0) as tab)
扫一扫
348
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
