Finding sum of column values in a single row 1

[jimoblak]

I've got a mental block. If I have a table that looks like this...

id, value1, value2, value3, total
1,1,1,1,[?]
2,2,5,4,[?]
3,4,1,1,[?]

What query could be used to update the value in the 'total' column as the sum of each row's value for 'value1', 'value2', and 'value3'?

The results I am seeking to replace [?] would be:

3
11
6

 

[feherke]

Hi

[b]update[/b] [green][i]tablename[/i][/green] [b]set[/b] total=value1+value2+value3

Feherke.

http://rootshell.be/~feherke/

 

[jimoblak]

Thanks. That is what I tried as my first query. Had I been intelligent enough to have been connected to the right database at the time, it would have worked then. I've been spinning my wheels on the query for the past 20 minutes. Oy.