一.删除数据库中的重复数据, 只留一条

 1 -- 删除数据库中的重复数据只留一条
 2 DELETE 
 3 FROM
 4     crm_member 
 5 WHERE
 6     id IN (
 7     SELECT
 8         a.id 
 9     FROM
10         (
11         SELECT
12             id 
13         FROM
14             crm_member 
15         WHERE
16             phone IN ( SELECT phone FROM crm_member GROUP BY phone HAVING count( phone ) > 1 ) 
17             AND id NOT IN ( SELECT min( id ) FROM crm_member GROUP BY phone HAVING count( phone ) > 1 ) 
18         ) a 
19     )

 

扫码关注我们
微信号：SRE实战
拒绝背锅 运筹帷幄

SRE实战 互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。