查询重复数据
SELECT `app`.name,`app`.packageFROM `app`,(
SELECT `package`,`status`
FROM `app` where `status` = 1
GROUP BY `package`
HAVING COUNT(1) > 1
) AS `t2`
WHERE `app`.`package` = `t2`.`package` and `app`.`status` = 1 and `t2`.`status` = 1 and `app`.`status` = `t2`.`status`;
删除
DELETE FROM `app_source`
USING `app_source`,(SELECT DISTINCT MIN(`id`) AS `id`,`name`
FROM `app_source`
GROUP BY `name`
HAVING COUNT(1) > 1
) AS `t2`
WHERE `app_source`.`name` = `t2`.`name`
AND `app_source`.`id` <> `t2`.`id`;