mysql 事件执行多个存储过程

DELIMITER $$

CREATE EVENT my_event
ON SCHEDULE EVERY 1 DAY
DO
BEGIN
    CALL procedure1();
    CALL procedure2();
    CALL procedure3();
END$$

DELIMITER ;

DELIMITER $$

CREATE EVENT my_event
ON SCHEDULE EVERY 1 DAY
DO
BEGIN
    DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
    BEGIN
        -- 错误处理逻辑
        ROLLBACK;
    END;

    START TRANSACTION;
    CALL procedure1();
    CALL procedure2();
    CALL procedure3();
    COMMIT;
END$$

DELIMITER ;

DELIMITER $$

CREATE EVENT my_event
ON SCHEDULE EVERY 1 DAY
DO
BEGIN
    CALL procedure1();
END$$

DELIMITER ;

DELIMITER $$

CREATE EVENT my_event2
ON SCHEDULE EVERY 1 DAY
STARTS (TIMESTAMP '2023-10-01 01:00:00')
DO
BEGIN
    CALL procedure2();
END$$

DELIMITER ;

DELIMITER $$

CREATE EVENT my_event3
ON SCHEDULE EVERY 1 DAY
STARTS (TIMESTAMP '2023-10-01 02:00:00')
DO
BEGIN
    CALL procedure3();
END$$

DELIMITER ;