mysql创建定时任务清理表数据select * from mysql.


-- 首先先查看mysql是否开启定时任务开关
SHOW VARIABLES LIKE 'event_scheduler'
-- 未开启设置开启
SET GLOBAL event_scheduler = ON;

-- 查看已经设置好的定时任务
select * from  mysql.event;


-- 创建定时任务   删除100天前的数据
DELIMITER $$  
DROP EVENT IF EXISTS  deleteLog;  
CREATE EVENT   deleteLog  
ON SCHEDULE EVERY 300 SECOND  
ON COMPLETION PRESERVE  
DO BEGIN  
  delete from pay_trate_order where TO_DAYS(now())-TO_DAYS(trade_time)>100;  
END$$  
DELIMITER ;

定时任务可根据情况进行多种用途