mysql 去除某字段重复数据只保留一条

 

原数据：

处理后：

 

 

 

 执行如下操作：

delete t from data t left join (select name,min(id) as min_id from data group by name)t1 on t.id = t1.min_id where t1.min_id is null;