Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

wwwxxxAPC, How to unsubscrube from dategen spam, WWWXXXAPC, docmd.close 2585, WWWXXXDOCO, nu vot, dhcpd lease file "binding state", WWWXXXDOCO, how to setup procmail to process html2text, how to setup procmail html2text

Links

XODOX
Impressum

#1: Deleting records older than X hours

Posted on 2011-08-01 08:30:39 by hezjing

--bcaec544eefc0ba77c04a96bc51d
Content-Type: text/plain; charset=UTF-8

Hi

I want to delete the records which are older than two hours from a table.

Currently, I have scheduled a cron job script to delete the records every
one hour. I'm wondering if there is a more elegant way of doing this with
out the cron job script?



--

Hez

--bcaec544eefc0ba77c04a96bc51d--

Report this message

#2: Re: Deleting records older than X hours

Posted on 2011-08-01 08:40:22 by sureshkumarilu

--20cf3040ec60d1602104a96be7c8
Content-Type: text/plain; charset=ISO-8859-1

use event scheduler.

On Mon, Aug 1, 2011 at 12:00 PM, hezjing <hezjing@gmail.com> wrote:

> Hi
>
> I want to delete the records which are older than two hours from a table.
>
> Currently, I have scheduled a cron job script to delete the records every
> one hour. I'm wondering if there is a more elegant way of doing this with
> out the cron job script?
>
>
>
> --
>
> Hez
>



--
Thanks
Suresh Kuna
MySQL DBA

--20cf3040ec60d1602104a96be7c8--

Report this message