<!--删除定时任务-->
DROP EVENT blog_info_delete;
<!--创建存储过程-->
CREATE PROCEDURE blog_info()
BEGIN
delete from blog_info where DATE(creater_time) <= DATE(DATE_SUB(now(),INTERVAL 7 DAY));
END;
<!--创建定时任务调用存储过程-->
create event blog_info_delete on SCHEDULE EVERY 1 DAY starts TIMESTAMP '2017-07-19 00:00:00'
DO CALL blog_info()
<!--创建存储过程-->
CREATE PROCEDURE blog_info_account_rel()
BEGIN
delete from blog_info_account_rel where DATE(creater_time) <= DATE(DATE_SUB(now(),INTERVAL 7 DAY));
END
<!--创建定时任务调用存储过程-->
create event blog_info_account_rel_del on SCHEDULE EVERY 1 DAY STARTS TIMESTAMP '2017-07-19 00:00:00'
DO CALL blog_info_account_rel()
