56,678
社区成员
发帖
与我相关
我的任务
分享
mysql> select @@event_scheduler;
+-------------------+
| @@event_scheduler |
+-------------------+
| ON |
+-------------------+
1 row in set (0.00 sec)
mysql> set global event_scheduler = 1;
Query OK, 0 rows affected (0.01 sec)
mysql> show variables like '%event_scheduler%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| event_scheduler | ON |
+-----------------+-------+
1 row in set (0.00 sec)
然后创建 event:
CREATE EVENT [IF NOT EXISTS] event_name
ON SCHEDULE every 1 day starts '2015-08-24 02:00:00'
DO call 你的存储过程();