mySQL Command Help????

[cheyner11]

Can I add two columns in a table to retrieve a third column.

AN example:

I want to set up a hockey website. In the Statistics column, I want to have games played, goals, assists, points, and points per game.

Column 1 (GP)= I will input

Column 2 (G)= I will input

Column 3 (A) = I will input

Column 4 (PTS)= I want mySQL to add column 2 and 3 (sum them)

Column 5 (PPG) = I want mySQL to divide column 1 and column 4.

I am new to mySQL but I know Microsoft Excel and this is very doable. Can someone please give me the commands I would input for this particular table.

Thank you very much.

[bastien]

select (col2 + col3) as stat1, (col1/col4)as stat2 from table

[cheyner11]

So I would not even include these columns in my database???

Should I just use PHP on the site to do the math for me??

Thanks for your help.

[bastien]

Anything that is calculated, as a general rule, should not be stored in the db...sql and/or application code can do all the calculation needed...

SELECT (
stat2 + stat3
)
as stat10, (
stat1 / ( stat2 + stat3 ) 
)
as stat11
FROM `stats`