1 message in com.mysql.lists.mysqlDelete oldest data
FromSent OnAttachments
Eric Mayers12 Feb 2002 16:22 
Subject:Delete oldest data
From:Eric Mayers (emay@captusnetworks.com)
Date:02/12/2002 04:22:02 PM
List:com.mysql.lists.mysql

I'm using MySQL-Max-3.23 and I need to keep a table from exceding a certain size. I plan on running a cron job that checks the size of the table and if its close to the max, executes a delete statement. The problem I have is that 3.23 doesn't support "delete from .. order by .." -- this was added in MySQL 4.x ..

Ideally I'd use "DELETE FROM table ORDER BY datestamp ASC LIMIT 10000", but of course this doesn't work.

How are people doing this in 3.23.xx?

Thanks, Eric Mayers