//查看已创建的定时器
//方法一:
select * from mysql.event;
//方法二:
show events;
//删除已经存在的定时器
drop event if exists event_userinfos;
//查看定时器是否开启
show variables like 'event_scheduler';
//开启定时器 0:off 1:on
set global event_scheduler = on;
//创建定时事件
create event event_userinfos
on schedule
every 8 hour
starts '2018-11-11 8:00:00'
do
update userinfos set createtime = now();
创建定时事件
最新推荐文章于 2024-10-02 06:14:43 发布