-- ----------------------------
-- 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 ;