Article From:https://www.cnblogs.com/vinzen/p/9967592.html

DELETE FROM new_collects
WHERE id IN
(SELECT id FROM (SELECT id FROM new_collects GROUP BY content HAVING count(*) > 1)e);

Leave a Reply

Your email address will not be published. Required fields are marked *