mysql: видалити усі записи з таблиці, окрім останніх N

DELETE FROM `table`
WHERE id NOT IN (
  SELECT id
  FROM (
    SELECT id
    FROM `table`
    ORDER BY id DESC
    LIMIT 10 -- keep this many records
  ) foo
);