CREATE VIEW vw_mytable AS
SELECT player, goals, assists,
(goals + assists) AS points
FROM mytable
ORDER BY player ASC;

This means whenever you change value in 'goals' or 'assists', you don't have to re-calculate a field. Any amount of calculations you want can be dealt with this way. Calculated fields in general should be avoided from base tables, because the proper place to handle them is usually in views. This is one of the rules of database normalization.