mysql - 无法在 MySQL 中安排存储过程

Question

我在这里做错了什么？我只想每天运行程序。

CREATE EVENT my_event
ON SCHEDULE EVERY 1 DAY
DO
BEGIN
CALL my_procedure("foo");
END $$

或者

CREATE EVENT my_event
ON SCHEDULE EVERY 1 DAY
DO CALL my_procedure("foo");

得到

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EVENT my_event
ON SCHEDULE EVERY 1 DAY
DO
BEGIN
CALL my_procedure' at line 1

Answer 1

试试这个查询

检查事件调度器是否关闭

select @@event_scheduler

如果它关闭了你必须将它打开

SET @@global.event_scheduler = ON;

如果 mysql 服务器关闭，事件调度程序将再次关闭