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;
页:
[1]