MySQL 事件不会执行

Question

谁能告诉我为什么这个事件不会执行？

CREATE EVENT add_recurring
ON SCHEDULE EVERY 1 MINUTE
    STARTS '2015-04-17 06:01:00'
DO INSERT INTO payment (amount, note, custID, type) 
   SELECT amount, note, custID, 'C' FROM recurring WHERE day = DATE_FORMAT(CURRENT_DATE(), '%e')

这是循环表的样子:

这是付款表，它没有获取事件输入的任何这些值:

Answer 1

尝试这些，假设开始日期是 future

1. 尝试添加 BEGIN 、 END 和 DELIMITER

   delimiter |
   
   CREATE EVENT add_recurring
     ON SCHEDULE
       EVERY 1 MINUTE
       STARTS '2015-04-17 06:01:00'
     DO
       BEGIN
         INSERT INTO payment (amount, note, custID, type), SELECT amount, note, custID, 'C' FROM recurring WHERE day = DATE_FORMAT(CURRENT_DATE(), '%e')
     END |
   
   delimiter ;
   

2. 确保甚至计划已打开。

   设置全局 event_scheduler = ON;设置全局 event_scheduler = 1;或者在 my.cnf 的 [mysqld] 部分下 event_scheduler=ON