Mysql 用while循环添加日期的存储过程

DELIMITER //

CREATE PROCEDURE add_dates()
BEGIN
    DECLARE start_date DATE;
    DECLARE end_date DATE;
    DECLARE current_date DATE;

    SET start_date = '2022-01-01';
    SET end_date = '2022-01-31';
    SET current_date = start_date;

    WHILE current_date <= end_date DO
        -- 在这里执行对日期的操作，例如插入到另一个表中
        -- INSERT INTO another_table (date_column) VALUES (current_date);

        SET current_date = DATE_ADD(current_date, INTERVAL 1 DAY);
    END WHILE;
END //

DELIMITER ;