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
>
>
> Hi,
> I want to per
Hi Akash
If using *nix investigate using the cron scheduler via crontab/at to execute
your SQL script at regular intervals. If you are running on NT/Win2K then
investigate using the task scheduler instead.
HTH
Rich
-Original Message-
From: Akash [mailto:[EMAIL PROTECTED]]
Sent: 20 January
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 schedule a job, which will execute a
