我想删除重复的行,但只针对每个产品id,下面是我的表数据:
运行delete语句后,最终结果如下所示:
到目前为止,我的问题是:
DELETE FROM `test` WHERE name IN (SELECT name FROM `test` GROUP BY name HAVING COUNT(name)>1)
https://stackoverflow.com/questions/50734162
相似问题