Adding numbers in mysql

[Silverfox2]

Is it possible within a mysql query to add the contents of several feilds. I.E. If I had a table with days of the week and on each day there was an amount of hours entered into it. Is it possible to be able to run a query that adds up the total ammount of hours week so far. Can anyone help please

 

[sleipnir214]

Something like

UPDATE tablename SET summation_field = hoursfield1 + hoursfield2 + hoursfield3

should do it. ______________________________________________________________________
TANSTAAFL!

 

[KarveR]

if you jsut want to output it the rsult, SELECT sum(fieldname); should do , where fieldname would be the name of the field conatining the "hours".

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[sleipnir214]

Oops, you're probably right KarveR.

I was thinking in terms of hours' being stored in columns, not in rows. ______________________________________________________________________
TANSTAAFL!