Fork me on Gitee

mysql定时任务

 1 -- 创建存储过程
 2 delimiter //
 3 create procedure `prc_del`(IN date_inter int) COMMENT '自动删除7天前数据'
 4 begin
 5 delete from xly where (TO_DAYS(NOW()) - TO_DAYS(IR_LASTTIME))>=date_inter; 
 6 end//
 7 
 8 -- 创建事件
 9 DROP EVENT IF EXISTS clear_xly_event;
10 
11 CREATE EVENT clear_xly_event
12 ON SCHEDULE EVERY 1 DAY
13 ON COMPLETION PRESERVE ENABLE
14 DO CALL prc_del(7);

每天定时删除七天前数据

posted @ 2018-11-05 15:31  MARK+  阅读(136)  评论(0编辑  收藏  举报