title: Incremental Count(*) using YEARWEEK
body: <p>I have a bunch of data stored in a table, each row ends with a <code>ts</code> column, type <code>TIMESTAMP</code>.  </p>
  
  <p>I want to get incremental counts up until a point, so for instance I have the following query:</p>
  
  <p><code>SELECT YEARWEEK(ts), DATE(ts), COUNT(*) FROM</code>order<code>WHERE DATE(ts) &gt;= '01/12/13' GROUP BY YEARWEEK(ts)</code></p>
  
  <p>Which produces something like:</p>
  
  <pre><code>201346  20/11/2013  59
  201347  24/11/2013  44
  201348  01/12/2013  21
  </code></pre>
  
  <p>However I need a column that adds up the COUNTS <em>up until</em> that point, so I'd need something like:</p>
  
  <pre><code>201346  20/11/2013  59 59
  201347  24/11/2013  44 103
  201348  01/12/2013  21 124
  </code></pre>
  
  <p>How can I achieve this with mysql??  It's for a line graph, so I need to show that the numbers go up each week and I can't do that with the current SQL statement.</p>