DELETE lignes en doublon

D'autres exemples ici : https://rootslabs.net/blog/423-mysql-comment-nettoyer-table-de-ces-doublons

ou encore là
https://sql.sh/138-methode-supprimer-doublons

La réponse est :

DELETE t1 FROM matable AS t1, matable AS t2 WHERE t1.Timestamp = t2.Timestamp AND t1.Type = 'orange'

DELETE
FROM tatable
HAVING count(Timestamp)>1

Ca ne fonctionne pas Jordane.

Et ma requête non plus.

DELETE FROM matable WHERE (SELECT * FROM matable as t1, matable as t2 WHERE t1.Timestamp = t2.Timestamp AND t1.Type = 'orange')

En fait le Type doit être égal à 'orange' avec un TIMESTAMP identique à un autre type.

Tu as une idée stp?

DELETE FROM matable
LEFT OUTER JOIN (
SELECT max(Type) as Type, Timestamp
FROM matable
GROUP BY Timestamp
) as t1
ON matable.id = t1.id
WHERE t1.id IS NULL

Ca ne fonctionne pas :(

La réponse est
ALTER IGNORE TABLE matable ADD UNIQUE INDEX(Timestamp)