delete the_table as a from the_table as a , (select min(id) as id,goodsurl from the_table group by goodsurl having count(goodsurl)>1) bwhere a.goodsurl = b.goodsurl and a.id>b.id
Mysql 删除重复记录,保留id最小的SQL语句。
最新推荐文章于 2024-09-12 01:15:37 发布