RE: how to write a scheduled job for MySQL

2003-01-20 Thread Adriaan . Putter
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 > >

RE: how to write a scheduled job for MySQL

2003-01-20 Thread Rich Gray
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&#

Re: how to write a scheduled job for MySQL

2003-01-20 Thread Rafal Jank
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

RE: how to write a scheduled job for MySQL

2003-01-20 Thread Greg_Cope
> 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

how to write a scheduled job for MySQL

2003-01-20 Thread Akash
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