mysql 删除商品名字重复数据,同时保留最新一条
delete goods where goods_id in (SELECT goods_id FROM goods
where goods_name in (
select goods_name from goods group by goods_name
having count(goods_name)>1
)
and goods_id not in (
select max(goods_id)
from goods group by goods_name having count(goods_name)>1
)
)
posted on 2022-01-08 16:54 lianruihong 阅读(62) 评论(0) 编辑 收藏 举报