Sum of Table

[Anon]

Is there there a way to get the sum of all entries in a table in mysql.

[brandonschnell]

SELECT SUM(all) FROM TABLE fear

[icaro]

select sum(colname) as sumvalue from tablename;