title: MySQL how to fill missing dates in range?
body: <p>I have a table with 2 columns, date and score. It has at most 30 entries, for each of the last 30 days one. </p>
  
  <pre><code>date      score
  -----------------
  1.8.2010  19
  2.8.2010  21
  4.8.2010  14
  7.8.2010  10
  10.8.2010 14
  </code></pre>
  
  <p>My problem is that some dates are missing - I want to see:</p>
  
  <pre><code>date      score
  -----------------
  1.8.2010  19
  2.8.2010  21
  3.8.2010  0
  4.8.2010  14
  5.8.2010  0
  6.8.2010  0
  7.8.2010  10
  ...
  </code></pre>
  
  <p>What I need from the single query is to get: 19,21,9,14,0,0,10,0,0,14... That means that the missing dates are filled with 0.</p>
  
  <p>I know how to get all the values and in server side language iterating through dates and missing the blanks. But is this possible to do in mysql, so that I sort the result by date and get the missing pieces.</p>
  
  <p>EDIT: In this table there is another column named UserID, so I have 30.000 users and some of them have the score in this table. I delete the dates every day if date &lt; 30 days ago because I need last 30 days score for each user. The reason is I am making a graph of the user activity over the last 30 days and to plot a chart I need the 30 values separated by comma. So I can say in query get me the USERID=10203 activity and the query would get me the 30 scores, one for each of the last 30 days. I hope I am more clear now.</p>