一开始从网上找到的sql:
delete from edm_email
where email in (select email from edm_email group by email having count(email) > 1)
and id not in (select min(id) from edm_email group by email having count(email )>1)
结果执行的时候报错:mysql You can't specify target table for update in FROM clause
后来改为:
DELETE from edm_email where email in( SELECT a.email FROM (select MIN(c.id),c.email from edm_email c group by c.email having(count(*)>1) ) a)