-- 删除重复的行 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
)
关注微信公众号获取更多有用信息
