title: How to get date increments in between start date and end date in MYSQL
body: <p>I have sample dates in a table and what I need to get is each of the months  between the start date and end date.</p>
  
  <p>sample : </p>
  
  <pre><code> ID   Startdate    EndDate
   1   01-01-2019  01-03-2019
   2   01-08-2019  01-02-2020
  </code></pre>
  
  <p>I need to fetch months and year from these dates.</p>
  
  <p>Desired output :</p>
  
  <pre><code>ID  Dates
  1  January 2019
  1  February 2019
  1  March 2019
  2  August 2019
  2  September 2019
  2  October 2019
  2  November 2019
  2  December 2019
  2  January 2020
  2  February 2020 
  </code></pre>
  
  <p>How cah I achieve this in MySQL and how to do increment or any loop kind of operation. On the query side I'm not getting any idea to move on this.</p>