On Nov 6, 2005, at 6:05 PM, Jeremy Cole wrote:
DELETE FROM tbl ORDER BY ts DESC LIMIT 100, 999999;
That's exactly needed: I was not aware of the OFFSET option. So I
tried this, which appears correct to me:
DELETE FROM table
WHERE field='somevalue'
ORDER BY timestamp DESC
LIMIT 100,99999999;
Also tried:
DELETE FROM table
WHERE field='somevalue'
ORDER BY timestamp DESC
LIMIT 99999999
OFFSET 100;
Either way I always get an error 1064, check the manual for the right
syntax to use near '99999999'. This is MySQL 4.1.15. Tearing my hair
out here. Any suggestion?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]