mysql删除重复记录,只保留一条。
来源:互联网 发布:抗韩中年人淘宝外设店 编辑:程序博客网 时间:2024/05/16 18:04
DELETE FROM mm_account WHERE devId IN ( SELECT devId FROM (SELECT devId,COUNT(*) FROM mm_accountGROUP BY devIdHAVING COUNT(*) > 1 ) AS a) ;
阅读全文
来源:互联网 发布:抗韩中年人淘宝外设店 编辑:程序博客网 时间:2024/05/16 18:04
DELETE FROM mm_account WHERE devId IN ( SELECT devId FROM (SELECT devId,COUNT(*) FROM mm_accountGROUP BY devIdHAVING COUNT(*) > 1 ) AS a) ;