Ilja: /MySQL5: Problem mit Abfragelogik

Beitrag lesen

yo,

DELETE FROM tabelle t1
WHERE t1.id NOT IN (SELECT t2.id
                    FROM tabelle t2
                    ORDER BY t2.timestamp
                    LIMIT 0, 10
                   )
;

Ilja