> On Nov 7, 2005, at 11:04 AM, Scott Noyes wrote:
>
>> delete from x where ID not in (select ID from x
order by timestamp desc
>> limit
>> 100);
>
> It's a good suggestion, I'm just shying away from it
because it seems
> more resource intensive than using an offset, and my
ISP is super anal
> about resources. I'd love to get the offset working
if possible.
>
Have you try the query above, I've got:
This version of MySQL doesn't yet support 'LIMIT &
IN/ALL/ANY/SOME subquery'
I am using 5.0.15.
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
