已验证:
DELETE FROM test WHERE id not in (select t.id from (select MAX(id) as id from test t1 GROUP BY url) t)
MySQL中查询、删除重复记录的方法大全
最新推荐文章于 2024-06-25 16:53:07 发布
已验证:
DELETE FROM test WHERE id not in (select t.id from (select MAX(id) as id from test t1 GROUP BY url) t)