mysql创建一个日历表

CREATE TABLE calendar (
    date DATE PRIMARY KEY,
    year INT,
    month INT,
    day INT,
    week INT,
    quarter INT,
    is_weekend BOOLEAN
);

DELIMITER //

CREATE PROCEDURE generate_calendar (IN start_date DATE, IN end_date DATE)
BEGIN
    DECLARE current_date DATE;
    SET current_date = start_date;

    WHILE current_date <= end_date DO
        INSERT INTO calendar (date, year, month, day, week, quarter, is_weekend)
        VALUES (
            current_date,
            YEAR(current_date),
            MONTH(current_date),
            DAY(current_date),
            WEEK(current_date),
            QUARTER(current_date),
            DAYOFWEEK(current_date) IN (1, 7)
        );

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

DELIMITER ;

CALL generate_calendar('2020-01-01', '2030-12-31');