how can I delete duplicate entries from a mysql database? The query to display them I have is:
Code: Select all
SELECT
DISTINCT url, COUNT( url ) AS qty
FROM
table
GROUP BY 1 HAVING qty > 1Many thanks
Moderator: General Moderators
Code: Select all
SELECT
DISTINCT url, COUNT( url ) AS qty
FROM
table
GROUP BY 1 HAVING qty > 1Code: Select all
CREATE new_tbl SELECT id, url
FROM old_tbl
GROUP BY url;