CREATE PROCEDURE `prc_del_taonlinelog_log`(IN date_inter int) COMMENT '自动删除日志'
BEGIN
delete from user where (TO_DAYS(NOW()) - TO_DAYS(createtime))>=date_inter;
END;
CREATE EVENT `auto_delete_log` ON SCHEDULE EVERY 1 DAY STARTS '2018-03-26 17:24:00'
BEGIN
delete from user where (TO_DAYS(NOW()) - TO_DAYS(createtime))>=date_inter;
END;
CREATE EVENT `auto_delete_log` ON SCHEDULE EVERY 1 DAY STARTS '2018-03-26 17:24:00'
ON COMPLETION PRESERVE ENABLE COMMENT '自动删除30天以前的日志数据' DO call prc_del_taonlinelog_log(30);
-- 30表示删除30天前的数据 createtime表示 user 表的createtime时间字段