MySQL:查找日期范围之间的缺失日期

SELECT DATE_ADD('2022-01-01', INTERVAL @i:=@i+1 DAY) AS missing_date
FROM (
    SELECT a.Date AS start_date, b.Date AS end_date
    FROM (SELECT MIN(Date) AS Date FROM table_name) AS a,
         (SELECT MAX(Date) AS Date FROM table_name) AS b
) AS dates,
(SELECT @i:=-1) AS i
WHERE DATE_ADD('2022-01-01', INTERVAL @i:=@i+1 DAY) BETWEEN start_date AND end_date
AND DATE_ADD('2022-01-01', INTERVAL @i:=@i+1 DAY) NOT IN (SELECT Date FROM table_name);