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 command every 24 hours inside of
> mysql?
> I'm using MySQL 5.0.51!
MySQL 5.1 added an event scheduler that would do what you need, but
there's nothing built into 5.0. You'll have to make do with cron jobs,
or check out upgrading to 5.1.
http://dev.mysql.com/doc/refman/5.1/en/events.html--
Dan Nelson
dnelson@stripped

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.