MySQL定期删除旧数据的过程和事件

-- ----------------------------
-- Procedure structure for my_deldata
-- ----------------------------
DROP PROCEDURE IF EXISTS `my_deldata`;
delimiter ;;
CREATE PROCEDURE `my_deldata`()
BEGIN
    

delete from a where createtime<DATE_ADD(CURRENT_DATE(),INTERVAL -1 year);
delete from b  where scanedtime<DATE_ADD(CURRENT_DATE(),INTERVAL -6 month);

END
;;
delimiter ;

-- ----------------------------
-- Event structure for my_deldata
-- ----------------------------
DROP EVENT IF EXISTS `my_deldata`;
delimiter ;;
CREATE EVENT `my_deldata`
ON SCHEDULE
EVERY '1' DAY STARTS '2022-03-01 02:00:00'
DO call my_deldata()
;;
delimiter ;