MYSQL 事件

DELIMITER $$

CREATE DEFINER=`root`@`%` EVENT `event_hour` ON SCHEDULE EVERY 1 HOUR STARTS '2022-02-23 01:00:00' ON COMPLETION PRESERVE ENABLE COMMENT '每小时' DO BEGIN
SET @hour = CONVERT(DATE_FORMAT(NOW(),'%k'), UNSIGNED INTEGER);
IF @hour>6 AND @hour<23 THEN
    IF @hour % 2 = 1 THEN
        CALL load_to_memory1();
    ELSE
        CALL load_to_memory2();
    END IF;
END IF;
END$$

DELIMITER ;

DELIMITER $$

ALTER DEFINER=`root`@`%` EVENT `event_day` ON SCHEDULE EVERY 1 DAY STARTS '2022-01-15 01:00:00' ON COMPLETION PRESERVE ENABLE COMMENT '每天1点0分0秒' DO BEGIN
SET @event_starttime = NOW();
IF CONVERT(DATE_FORMAT(NOW(),'%e'), UNSIGNED INTEGER) = 1 THEN
    CALL build_month_sample();
    CALL build_month_pro();
END IF;
CALL build_sample_new();
CALL build_pro_new();
CALL build_pro_state();
CALL build_pro_model_fac();
CALL build_pro_numidx();
CALL build_pro();
SET @REMARK = '写日志';
SET @event_endtime = NOW();
SET @event_timediff = UNIX_TIMESTAMP(@event_endtime) - UNIX_TIMESTAMP(@event_starttime);
INSERT IGNORE INTO `event_log` VALUES(NULL,'event_day_2',@event_starttime,@event_endtime,@event_timediff);
END$$

DELIMITER ;