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