mysql查询删除重复字段

查询某个字段

SELECT `gwlink`,count(`gwlink`) as count FROM `q_recnitment` GROUP BY `gwlink` HAVING count(`gwlink`) >1 ORDER BY count DESC;

删除重复多余的数据

create table tmp as select min(id) as col1 from q_recnitment group by gwlink;
delete from q_recnitment where id not in (select col1 from tmp); 
drop table tmp;