Does MySQL have time-based triggers?

问题:

I would like to execute a procedure periodically, how to do that in MySQL?

回答1:

If you have MySQL 5.1 you can use events.

http://dev.mysql.com/doc/refman/5.1/en/events.html

回答2:

MySQL allow this with the Event Scheduler : http://dev.mysql.com/doc/refman/5.1/en/events.html