mysql 生成月份表

CREATE TABLE IF NOT EXISTS month_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    year INT NOT NULL,
    month INT NOT NULL,
    start_date DATE NOT NULL,
    end_date DATE NOT NULL
);

DELIMITER $$
CREATE PROCEDURE generate_month_table()
BEGIN
    DECLARE v_year INT DEFAULT 2020;
    DECLARE v_month INT DEFAULT 1;
    DECLARE v_end_date DATE;

    WHILE v_year <= 2030 DO
        SET v_end_date = LAST_DAY(CONCAT(v_year, '-', v_month, '-01'));
        INSERT INTO month_table (year, month, start_date, end_date)
        VALUES (v_year, v_month, CONCAT(v_year, '-', v_month, '-01'), v_end_date);

        SET v_month = v_month + 1;
        IF v_month > 12 THEN
            SET v_month = 1;
            SET v_year = v_year + 1;
        END IF;
    END WHILE;
END$$
DELIMITER ;

CALL generate_month_table();