删除重复并保留一条mysql
DELETE FROM tbname WHERE id IN (
SELECT id from (
SELECT id FROM tbname WHERE oldurl in(
SELECT oldurl FROM tbname GROUP BY oldurl HAVING count(oldurl) > 1)
AND id not IN(SELECT min(id) FROM tbname GROUP BY oldurl HAVING count(oldurl) > 1)
) as t
);