title: MySQL: How can fetch SUM() of all fields in one Query?
body: <p>I just want somthing like this:</p>
  
  <pre><code>select SUM(*) from `mytable` group by `year`
  </code></pre>
  
  <p>any suggestion?</p>
  
  <p>(I am using Zend Framework; if you have a suggestion using ZF rather than pure query would be great!)</p>
  
  <p><strong>Update:</strong> <strong><em>I have a mass of columns in table and i do not want to write their name down one by one.</em></strong></p>
  
  <hr>
  
  <p>No Idea??</p>