MySQL: How can fetch SUM() of all fields in one Query?

Question

I just want somthing like this:

select SUM(*) from `mytable` group by `year`

any suggestion?

(I am using Zend Framework; if you have a suggestion using ZF rather than pure query would be great!)

Update: I have a mass of columns in table and i do not want to write their name down one by one.

---

No Idea??

Answer 1

SELECT      SUM(column1) + SUM(column2) + SUM(columnN) 
FROM        mytable 
GROUP BY    year