--创建 定时任务 每天删除三天前`t_pass_person_feature` 表中的数据
CREATE EVENT `clearPPF` (必须执行)
ON SCHEDULE EVERY 1 DAY STARTS '2016-08-01 00:00:00'
ON COMPLETION PRESERVE ENABLE
DO
delete from `t_pass_person_feature` where `pass_time` <= DATE_SUB(curdate(),INTERVAL 3 DAY)
-- 开启定时任务(必须执行)
set global event_scheduler = on
----------以下为日常维护使用--------
--关闭任务
SET GLOBAL event_scheduler = OFF
-- 查询任务详情
select * from mysql.event
--开启某事件:
ALTER EVENT `clearPPF` ON COMPLETION PRESERVE ENABLE;
--关闭某事件:
ALTER EVENT `clearPPF` ON COMPLETION PRESERVE DISABLE;
--删除
drop EVENT `clearPPF`;
--查询事件是否启用
SHOW VARIABLES LIKE 'event_scheduler';