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 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
