delete FROM `customer` WHERE `name` in
(SELECT a.name from( select name FROM `customer`
GROUP BY `name`
HAVING COUNT(1) >1)a
) and id not in
(SELECT b.id FROM(
select max(id) as id from customer group by name having count(1)>1
)b)
max() 保留大的
min() 保留小的