Re: [GENERAL] Limit record count

[Rodrigo Gonzalez]

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

Sean Z. escribió:

Hi,



Thanks a lot!
Sean

------------------------------------------------------------------------

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. Never miss a thing. Make Yahoo your homepage. <http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs>

smime.p7s
Description: S/MIME Cryptographic Signature