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
No. You need to use MySQL 5.1 as that is now a standard feature.
Or, if all your functionality is 100% MySQL, just run a stored procedure in an
infinite loop and check every 60 seconds for
DELIMITER $$
DROP PROCEDURE IF EXISTS `rolando`.`runjob` $$
CREATE PROCEDURE `rolando`.`runjob` (scheduled
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
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
-
