https://blog.csdn.net/pan_junbiao/article/details/86489237
https://www.cnblogs.com/itfenqing/p/6884650.html
五.查看和删除事件
show events;
show create EVENT test2_insert_5_minute;
drop event test2_insert_5_minute;
----------------------------------
-- 插入数据【5秒】
CREATE EVENT IF NOT EXISTS event_word_user
ON SCHEDULE EVERY 5 SECOND
ON COMPLETION PRESERVE
COMMENT '新增用户信息定时任务'
DO INSERT INTO fa_word_user(name,nickname,mobile,work_number,createtime,work_number_time) VALUES('小李','小李昵称','18302088970',55,UNIX_TIMESTAMP(NOW()),NOW());
-- 更新数据【每天】
-- 从2020-3-15 00:10:00开始,每天的00:10:00执行定时任务
CREATE EVENT IF NOT EXISTS event_word_user
ON SCHEDULE EVERY 1 DAY STARTS '2020-3-15 00:05:00'
ON COMPLETION NOT PRESERVE
COMMENT '更新用户信息定时任务'
DO UPDATE fa_word_user SET name='测试凌晨定时更新数据',work_number=0,work_number_ti