My geuss would be to write a sql script
and run it from cron
mysql < script.sql
> -Original Message-
> From: Akash [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 20, 2003 1:52 PM
> To: [EMAIL PROTECTED]
> Subject: how to write a scheduled job for MySQL
>
>
January 2003 11:52
To: [EMAIL PROTECTED]
Subject: how to write a scheduled job for MySQL
Hi,
I want to periodically delete some records from a table. Is there any
mechanism by which I can schedule a job, which will execute a particular
query at periodic intervals ?
MySQL currently doesn
On Mon, 20 Jan 2003 17:21:59 +0530
Akash <[EMAIL PROTECTED]> wrote:
> Hi,
> I want to periodically delete some records from a table. Is there any
> mechanism by which I can schedule a job, which will execute a particular
> query at periodic intervals ?
> MySQL currently doesn't support sto
> From: Akash [mailto:[EMAIL PROTECTED]]
> Sent: 20 January 2003 11:52
> To: [EMAIL PROTECTED]
> Subject: how to write a scheduled job for MySQL
>
>
> Hi,
> I want to periodically delete some records from a table.
> Is there any
> mechanism by which I can sche
Hi,
I want to periodically delete some records from a table. Is there any
mechanism by which I can schedule a job, which will execute a particular
query at periodic intervals ?
MySQL currently doesn't support stored procedures and triggers... but I
guess, there must be some way around. If a