mysql 创建月份

CREATE TABLE months (
    id INT AUTO_INCREMENT PRIMARY KEY,
    month_name VARCHAR(20),
    start_date DATE,
    end_date DATE
);

SELECT DATE_FORMAT(NOW(), '%Y-%m') AS month;

SELECT DATE_FORMAT(DATE_ADD('2020-01-01', INTERVAL n MONTH), '%Y-%m') AS month
FROM (
    SELECT @rownum:=@rownum+1 AS n
    FROM (SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9 UNION ALL SELECT 10 UNION ALL SELECT 11 UNION ALL SELECT 12) r,
    (SELECT @rownum:=0) n
) numbers
WHERE DATE_ADD('2020-01-01', INTERVAL n MONTH) <= '2021-01-01';