Hello, im erchache from EL (enciclopedia.us.es).
I want to update from 1.3.11 to 1.4.x but i have
duplicate entries on image table, and program doesnt
finish update process.
With this sentence i can see all duplicated entries:
SELECT img_name FROM image GROUP BY img_name HAVING
count(img_name) > 1;
But now i cant do a delete with a subquery to erase
duplicate entries less one.
+-----------------------------------------------------+-----------------+
| img_name
| count(img_name) |
+-----------------------------------------------------+-----------------+
| Ac.artemisephesus.jpg
| 2 |
This is a example. i want to delete all duplicate
entries and set it to 1.
Any can help me? I want to make it with sql sentences
to automate process.
Im waiting for your replies.
Thanks.
______________________________________________
Renovamos el Correo Yahoo!
Nuevos servicios, más seguridad
http://correo.yahoo.es