mysql 怎么建维度表

CREATE TABLE time_dimension (
    time_id INT PRIMARY KEY AUTO_INCREMENT,
    date DATE NOT NULL,
    year INT NOT NULL,
    quarter INT NOT NULL,
    month INT NOT NULL,
    day INT NOT NULL,
    day_of_week VARCHAR(10) NOT NULL
);

-- 插入数据
INSERT INTO time_dimension (date, year, quarter, month, day, day_of_week)
SELECT 
    DATE_ADD('2000-01-01', INTERVAL n DAY) AS date,
    YEAR(DATE_ADD('2000-01-01', INTERVAL n DAY)) AS year,
    QUARTER(DATE_ADD('2000-01-01', INTERVAL n DAY)) AS quarter,
    MONTH(DATE_ADD('2000-01-01', INTERVAL n DAY)) AS month,
    DAY(DATE_ADD('2000-01-01', INTERVAL n DAY)) AS day,
    DAYNAME(DATE_ADD('2000-01-01', INTERVAL n DAY)) AS day_of_week
FROM (
    SELECT a.N + b.N * 10 + c.N * 100 AS n
    FROM (SELECT 0 AS N UNION ALL 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) a
    CROSS JOIN (SELECT 0 AS N UNION ALL 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) b
    CROSS JOIN (SELECT 0 AS N UNION ALL 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) c
) numbers
WHERE DATE_ADD('2000-01-01', INTERVAL n DAY) <= '2023-12-31';