MySQL如何填写范围内的缺失日期？

CREATE TABLE date_generator (
    date_value DATE PRIMARY KEY
);

INSERT INTO date_generator (date_value)
SELECT DATE('开始日期') + INTERVAL (a.a + (10 * b.a) + (100 * c.a)) DAY
FROM (SELECT 0 AS a 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) AS a
CROSS JOIN (SELECT 0 AS a 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) AS b
CROSS JOIN (SELECT 0 AS a 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) AS c
WHERE DATE('开始日期') + INTERVAL (a.a + (10 * b.a) + (100 * c.a)) DAY <= '结束日期';

SELECT g.date_value
FROM date_generator g
LEFT JOIN your_table t ON g.date_value = t.date_column
WHERE t.date_column IS NULL;