mysql插入连续的一段日期

CREATE TABLE dates_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    date_column DATE
);

DELIMITER //

CREATE PROCEDURE InsertDates(IN startDate DATE, IN endDate DATE)
BEGIN
    DECLARE currentDate DATE := startDate;
    WHILE currentDate <= endDate DO
        INSERT INTO dates_table (date_column) VALUES (currentDate);
        SET currentDate = DATE_ADD(currentDate, INTERVAL 1 DAY);
    END WHILE;
END //

DELIMITER ;

CALL InsertDates('2023-01-01', '2023-01-10');

INSERT INTO dates_table (date_column) VALUES
('2023-01-01'), ('2023-01-02'), ('2023-01-03'), ...;