– Event structure for delete_historylog_data_event
DROP EVENT IF EXISTS delete_historylog_data_event
;
DELIMITER ;;
CREATE EVENT delete_historylog_data_event
ON SCHEDULE EVERY 1 DAY STARTS ‘2019-10-23 01:00:00’ ON COMPLETION PRESERVE ENABLE DO call delete_historylog_data()
;;
DELIMITER ;