如何在sql中通过ID在表中填充缺少的日期

-- 创建日期表
CREATE TABLE date_table (
  date_column DATE
);

-- 填充日期表
INSERT INTO date_table (date_column)
SELECT DATE_ADD('start_date', INTERVAL seq.seq DAY) AS date_column
FROM (
  SELECT (HUNDREDS + TENS + ONES) AS seq
  FROM
    (SELECT 0 AS HUNDREDS 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) H,
    (SELECT 0 AS TENS UNION ALL SELECT 10 UNION ALL SELECT 20 UNION ALL SELECT 30 UNION ALL SELECT 40 UNION ALL SELECT 50 UNION ALL SELECT 60 UNION ALL SELECT 70 UNION ALL SELECT 80 UNION ALL SELECT 90) T,
    (SELECT 0 AS ONES 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) O
) seq
WHERE DATE_ADD('start_date', INTERVAL seq.seq DAY) <= 'end_date';

-- 填充缺少的日期
INSERT INTO table_name (date_column)
SELECT date_column
FROM date_table
LEFT JOIN table_name ON date_table.date_column = table_name.date_column
WHERE table_name.date_column IS NULL;