Kashub's Code Barn - "MySql Delete duplicate entry by single SQL"

podświetlone jako mysql (dodał(a) technikq.blogspot.com @ 2013-01-07 13:43:57)

Twoja wyszukiwarka

DELETE T2
FROM   TABLE T1
JOIN   TABLE T2 ON (T2.value = T1.value )  AND
                   T2.TABLE_ID > T1.TABLE_ID);