Adding up a column in mysql

[foe]

From MySQL's documentation:

SUM(expr)
Returns the sum of expr. Note that if the return set has no rows, it returns NULL!

So,
SELECT SUM(thecolumn) FROM thetable

[OhLordy]

Yes, it's often easier to write it like
SELECT SUM(the_column) AS sum FROM table
HTH
Rob