-- 删除重复的行 id是自增列 删除最小id那个
DELETE FROM news
WHERE id IN (
SELECT t.minid
FROM (
SELECT MIN(id) as minid
FROM news
GROUP BY title
HAVING COUNT(*) > 1
) t
)
Share this tool
-- 删除重复的行 id是自增列 删除最小id那个
DELETE FROM news
WHERE id IN (
SELECT t.minid
FROM (
SELECT MIN(id) as minid
FROM news
GROUP BY title
HAVING COUNT(*) > 1
) t
)