Generate Dates between Date Ranges in mysql
I tried this solution :

WITH recursive Date_Ranges AS (
    select '2018-11-30' as Date
   union all
   select Date + interval 1 day
   from Date_Ranges
   where Date &lt; '2018-12-31')
select * from Date_Ranges;