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;