mysql定时任务

-- 创建存储过程
delimiter //
create procedure `prc_del`(IN date_inter int) COMMENT '自动删除7天前数据'
begin
delete from xly where (TO_DAYS(NOW()) - TO_DAYS(IR_LASTTIME))>=date_inter; 
end//

-- 创建事件
DROP EVENT IF EXISTS clear_xly_event;

CREATE EVENT clear_xly_event
ON SCHEDULE EVERY 1 DAY
ON COMPLETION PRESERVE ENABLE
DO CALL prc_del(7);

每天定时删除七天前数据