Hello I need to empty all table except the x new rows i have already test

[How to delete all rows from a table except newest 10 rows](https://stackoverflow.com/questions/16797682/how-to-delete-all-rows-from-a-table-except-newest-10-rows)

[SQL Delete all rows except for last 100](https://stackoverflow.com/questions/26206009/sql-delete-all-rows-except-for-last-100)

But not work, my mysql version doesn't support limit "IN"
(actual version Ver 14.14 Distrib 5.5.46)

My table is like that

```
ID (int)
DATE (timestamp)

```

Who i can empty without loop ? Thanks