Re: Delete all but the newest 100 records?

[Brian Dunning]

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.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]