Обсуждение: Limit record count

Поиск
Список
Период
Сортировка

Limit record count

От
"Sean Z."
Дата:
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.

Re: 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,
>
> 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>
Вложения