DELETE FROM mm_account WHERE
devId IN (
SELECT devId FROM (
SELECT devId,COUNT(*) FROM mm_account
GROUP BY devId
HAVING COUNT(*) > 1
) AS a
) ;
mysql删除重复记录,只保留一条。
最新推荐文章于 2024-07-11 10:27:20 发布
DELETE FROM mm_account WHERE
devId IN (
SELECT devId FROM (
SELECT devId,COUNT(*) FROM mm_account
GROUP BY devId
HAVING COUNT(*) > 1
) AS a
) ;