Jul 29

MySQL: Doppelte Einträge per Subselect löschen

MySQL Add comments
DELETE adressen FROM adressen,
(SELECT count(*) as counter,
min(id) as id,
name, anschrift, plz, ort
from adressen
GROUP BY name, anschrift, plz, ort
HAVING counter > 1) as doppel
WHERE adressen.name = doppel.name and
adressen.anschrift = doppel.anschrift and
adressen.plz = doppel.plz and
adressen.ort = doppel.ort and
adressen.id != doppel.id;

0 Antworten auf “MySQL: Doppelte Einträge per Subselect löschen”

Antworten





Powered by Mango Blog. ©2012 Patrick Heppler. Design inspired by the GlossyBlue Theme © N.Design Studio.