找出重复行并进行删除

##找出重复行
create table t1 as (select t.tname,t.tname2, count(*) cnt from  test1 t   group by t.`tname`,t.`tname2` having cnt>1 order by  t.tname ,t.tname2);

 

##从t1中选出id最大的那一行

create table t2 as (select max(t1.tid) maxid,t1.tname,t1.tname2 from t1 );

 

##删除重复行

delete from test1 t where t.tid !=(select maxid from t2 where t.tname=t2.tname and t.tname2=t2.tname2);