delete from biz_car_info
– 除了要保留的,其它全部删除
where car_id not in
(
select id
from
(
– 重复数据取id最大一条,plate为判断唯一字段
select max(car_id) as id from biz_car_info group by plate having count() >1
UNION
– 加上只有一条的数据
select max(car_id) from biz_car_info group by plate having count() =1) t
)
mysql删除多条重复保留一条
最新推荐文章于 2024-07-11 10:27:20 发布