List:General Discussion« Previous MessageNext Message »
From:Suresh Kuna Date:August 1 2011 6:40am
Subject:Re: Deleting records older than X hours
View as plain text  
use event scheduler.

On Mon, Aug 1, 2011 at 12:00 PM, hezjing <hezjing@stripped> 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

Thread
Deleting records older than X hourshezjing1 Aug
  • Re: Deleting records older than X hoursSuresh Kuna1 Aug