mysql删除重复数据只保留一条

 

create table tmp  select distinct(tu.tuhao),tu.tuming,tu.gangkouming,tu.bilichi,
tu.zuoxiajiaoweidu,tu.zuoxiajiaojingdu,tu.youshangjiaoweidu,
tu.youshangjiaojingdu,tu.tupian,tu.chubanshijian,tu.gaibanshijian,tu.banci,tu.zuixinban FROM tu ;

drop table tu;
create table tu select * from tmp;
drop table tmp;