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