mysql event 任务

SET GLOBAL event_scheduler = ON;
SET @@global.event_scheduler = ON;
SET GLOBAL event_scheduler = 1;
SET @@global.event_scheduler = 1;

show VARIABLES like 'event_scheduler';

每2分钟执行程序

create event tourist_del_hour  
on schedule every 2 MINUTE  
do   
delete from xxx where status = '0' 
and UNIX_TIMESTAMP(createTime) < UNIX_TIMESTAMP(NOW()) - 3600*24*2;