title: generate_series() equivalent in MySQL
body: <p>I need to do a query and join with all days of the year but in my db there isn't a calendar table.<br>
  After google-ing I found <code>generate_series()</code> in PostgreSQL. Does MySQL have anything similar? </p>
  
  <p>My actual table has something like:</p>
  
  <pre><code>date     qty
  1-1-11    3
  1-1-11    4
  4-1-11    2
  6-1-11    5
  </code></pre>
  
  <p>But my query has to return:</p>
  
  <pre><code>1-1-11    7
  2-1-11    0
  3-1-11    0
  4-1-11    2
  and so on ..
  </code></pre>