title: How can i create a Date table in SQL that will automatically fill itself
body: <p>I wanna create a table in SQL with the following 4 colums: id, year, month and day. But i wanna fill this colums automatically from the year of 2012 to 2020. What is the best way to do this? i googled but i couln't really find a solution. For example i want the table to show the following information.</p>
  <pre><code>ID  year  Month Day
  1   2013   1     2
  2   2013   1     3
  3   2013   1     4
  4   2013   1     5
  </code></pre>