mysql去除重复数据

• 查询重复数据：

select phone,count(phone) as c from client group by phone having c>1;

• 去除重复数据，只保留一个：

delete from client where id not in (select * from (select id from client group by phone) b )