Re: Triggering an action every 24 hours

2008-05-22 Thread Samuel Vogel
Dan Nelson schrieb: In the last episode (May 22), Samuel Vogel said: Hey, I am wondering how I can trigger an Action every 24 hours inside of mysql. A cron job would also do the job, but it won't work on shared hosts and it's just another point of failure. So is there any way to run a spe

RE: Triggering an action every 24 hours

2008-05-22 Thread Rolando Edwards
; -Original Message- From: Samuel Vogel [mailto:[EMAIL PROTECTED] Sent: Thursday, May 22, 2008 2:28 PM To: MYSQL General List Subject: Triggering an action every 24 hours Hey, I am wondering how I can trigger an Action every 24 hours inside of mysql. A cron job would also do the job, but it won&#

Re: Triggering an action every 24 hours

2008-05-22 Thread Dan Nelson
In the last episode (May 22), Samuel Vogel said: > Hey, > > I am wondering how I can trigger an Action every 24 hours inside of mysql. > A cron job would also do the job, but it won't work on shared hosts and > it's just another point of failure. > > So is there any way to run a specific SQL com

Triggering an action every 24 hours

2008-05-22 Thread Samuel Vogel
Hey, I am wondering how I can trigger an Action every 24 hours inside of mysql. A cron job would also do the job, but it won't work on shared hosts and it's just another point of failure. So is there any way to run a specific SQL command every 24 hours inside of mysql? I'm using MySQL 5.0.51

Re: triggering

2002-09-18 Thread Paul DuBois
At 5:45 +0300 9/19/02, Hytham Shehab wrote: >hi guys, > is it possible to write triggers and procedures in mysql? Not according to the manual. http://www.mysql.com/doc/en/ANSI_diff_Triggers.html > > >thx >sql >-- >Hytham Shehab -

triggering

2002-09-18 Thread Hytham Shehab
hi guys, is it possible to write triggers and procedures in mysql? thx sql -- Hytham Shehab - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list a