MySQL事件语法非常简单-

The MySQL event syntax is very simple -

DELIMITER $$
CREATE EVENT event1
ON SCHEDULE EVERY '1' MONTH
STARTS '2011-05-01 00:00:00'
DO 
BEGIN
 -- your code
END$$

DELIMITER ;

该事件将从"2011-05-01"的"00:00:00"开始(日期时间必须在将来).

Event will start working on '2011-05-01' at '00:00:00' (datetime must be in a future).

更多信息-使用事件计划程序

不要忘记启用全局事件调度线程-

Do not forget to enable global event scheduling thread -

SET GLOBAL event_scheduler = 1;