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 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
