Deleting records older than X hours

--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--

Re: Deleting records older than X hours

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

use event scheduler.

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