mysql 中的事件调度程序每 1 分钟运行一次
CREATE EVENT `user_created_this_month_schedule`
ON SCHEDULE EVERY 1 MINUTE STARTS '2018-08-31 15:35:00'
ON COMPLETION NOT PRESERVE
ENABLE
DO update user_data set user_created_this_month = 0 where user_data_id = 7
试试这个:
SET GLOBAL event_scheduler="ON";
CREATE EVENT `user_created_this_month_schedule`
ON SCHEDULE EVERY 1 MINUTE STARTS '2018-08-31 15:35:00'
ON COMPLETION NOT PRESERVE ENABLE DO UPDATE user_data SET user_created_this_month = 0 WHERE user_data_id = 7;
SHOW EVENTS;