开启事件调度器

//查看是否开启高度器
SHOW VARIABLES LIKE 'event_scheduler';

//开启事件调度器
SET GLOBAL event_scheduler = ON;

//关闭事件调度器
SET GLOBAL event_scheduler = OFF;

//第天定时清空某个表
create event table_truncate on schedule every 1 day starts '2022-01-01 04:15:00' do truncate table operator_record_log;

create event table_truncate1 on SCHEDULE 
every 1 day starts '2022-01-01 04:47:00' do truncate table tbl_visit_verify_info;


//查看所有的事件
show EVENTS;

禁用事件
alter event event_name disable;

启用事件
alter event event_name enable;

删除事件
drop event if exists event_name;