DELETE a from nature_product a
JOIN (
select count(*) as count,custom_code,MIN(id) as id
from nature_product GROUP BY custom_code HAVING count >1
) b on a.custom_code = b.custom_code and a.id > b.id
mysql删除重复数据sql
最新推荐文章于 2024-07-27 19:11:07 发布