Delete duplicate enties
Posted: Wed May 17, 2006 2:48 am
Hi
how can I delete duplicate entries from a mysql database? The query to display them I have is:
But how can I delete them?
Many thanks
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