Put a SELECT into my column

Question

My table has 4 columns. I want the last column to be a SUM of the previous 3 columns.

I can use a select command to get the result I want:

SELECT strength + agility + defense AS StatSum FROM userstats

How do I do this?

EDIT: I am looking how to place the SELECT command in the column so that column 4 will display the sum of each row.

possible duplicate of [Column calculated from another column?](http://stackoverflow.com/questions/5222044/column-calculated-from-another-column) — Jimmy T., Apr 12 '15 at 13:13

score 0 · Answer 1 · answered Apr 12 '15 at 13:08

0

Try soemthing like:

 SELECT strength, agility, defense, (strength + agility + defense) AS StatSum 
 FROM userstats

answered Apr 12 '15 at 13:08

SMA

The SELECT command works. I was asking how to place the select command in a column. So the command runs works out the total stats for each row – adam7918 Apr 12 '15 at 13:11
No that wont be possible. – SMA Apr 12 '15 at 13:13
You could do it with your application layer – nomistic Apr 12 '15 at 14:11

score 0 · Answer 2 · answered Apr 12 '15 at 13:12

0

MySQL does not support calculated values for a column.

The only thing you could do is to use a view

answered Apr 12 '15 at 13:12

Jimmy T.

2 Answers2