mysql删除重复的数据
select field ,count(1) from table group by filed having count(1)>1 t 查找出你要删除的数据 delect from table where filed not in select t.field ( (select field from table group by filed having count(1)>1 )t )
一点点学习,一丝丝进步。不懈怠,才不会被时代淘汰
select field ,count(1) from table group by filed having count(1)>1 t 查找出你要删除的数据 delect from table where filed not in select t.field ( (select field from table group by filed having count(1)>1 )t )