Re: Limit record count

[Rodrigo Gonzalez <rjgonzale@xxxxxxxxx>]

DELETE FROM <table> WHERE <id> NOT IN (SELECT <id> FROM <table> ORDER BY 
<id> DESC LIMIT 50)

Sean Z. escribió:
> Hi,
>
> I need to write a maintenance function to delete oldest records of a 
> table, leaving only a certain number of records, say 50.  The task 
> should run once per day.  How can I write it? 
> The oldest record carries the smallest ID.
>
> Thanks a lot!
> Sean
>
> ------------------------------------------------------------------------
> Never miss a thing. Make Yahoo your homepage. 
> <http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs>

<<attachment: smime.p7s>>