DELETE does support the offset
(http://dev.mysql.com/doc/refman/5.0/en/delete.html) the problem is you have an
erroneous equals character:
You wrote:
DELETE FROM tablename ORDER BY creation DESC LIMIT=n
You need:
DELETE FROM tablename ORDER BY creation DESC LIMIT offset, count
HTH,
--Rob
My bad, the = was my own typo just in the email, it's not in my
actual query. I've tried using offset (delete...limit 50,99) and
it returns an error, and it is not documented (search that page you
referenced for offset).
On Oct 4, 2006, at 9:04 AM, Rob Desbois wrote:
DELETE does