删除表中重复的数据，其中某列数据相同

INSERT INTO  t_info_whitelist_copy

SELECT *,count(distinct telephone) FROM `t_info_whitelist` group by telephone;

 

 

insert into t_info_whitelist select * from t_info_whitelist_copy;