1.检查是否开启了事件
查看event是否开启 : SHOW VARIABLES LIKE '%event_sche%';
将事件计划开启 : SET GLOBAL event_scheduler = 1;
将事件计划关闭 : SET GLOBAL event_scheduler = 0;
关闭事件任务 : ALTER EVENT eventName ON COMPLETION PRESERVE DISABLE;
开启事件任务 : ALTER EVENT eventName ON COMPLETION PRESERVE ENABLE;
查看事件任务 : SHOW EVENTS ;
2.创建
a.sql创建
CREATE EVENT `test`
ON SCHEDULE
EVERY '5' SECOND STARTS '2019-05-31 16:18:28'
DO update user set register_date = now();
b.在navicat里创建