Is there a query that will, say, trim a table down to a million rows (with some sort order, of course, as I'm interested in deleting the oldest ones)?
If you have got a datecolumn, you might also want to delete anything that is older than x days (2 in my example):
DELETE FROM database.table WHERE datecolumn <= DATE_SUB(sysdate(),INTERVAL 2 day);
Regards Dominik -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
