MySQL是否有基于时间的触发器?

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

我想定期执行一个过程，如何在MySQL中执行?

2 个解决方案

#1

If you have MySQL 5.1 you can use events.

如果你有MySQL 5.1，你可以使用事件。

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

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

MySQL允许使用事件调度器:http://dev.mysql.com/doc/refman/5.1/en/events.html