Delete oldest records from mysql db

[Anon]

I'm wondering how can I delete the oldest rows from a db.
When the db reaches 1000 rows and you add a new row it deletes the oldest one..

[Anon]

Quick turnaround :
Ignore the extra rows with
SELECT ... ORDER BY datefield DESC LIMIT 1000

Delete the other unnecessary rows occasionally.
In most cases database size doesnt matter for a lot of thousands rows.