DELETE
FROM
m_leads
WHERE
mobile IN ( SELECT mobile FROM m_leads GROUP BY mobile HAVING count( * ) > 1 )
AND id NOT IN ( SELECT min( id ) FROM m_leads GROUP BY mobile HAVING count( * ) > 1 )
mysql 去重语句
最新推荐文章于 2024-04-17 15:25:46 发布