mysql:指定日から連続する日数分の一覧(行)を求める

SELECT
  DATE_ADD('2020-08-01', INTERVAL T.number DAY) AS date
FROM (
  SELECT @num := 0 AS number
  UNION ALL
  SELECT @num := @num + 1 FROM information_schema.COLUMNS
  LIMIT 10
) AS T
;