Adding values from a column in MySQL
Moderator: General Moderators
-
HansKippenhagen
- Forum Newbie
- Posts: 1
- Joined: Fri Jun 20, 2003 11:06 pm
Adding values from a column in MySQL
Does anyone know how to add all of the values in a column. I suppose you could use mysql_fetch_array but i was wondering if there were a easier way. thanks
- trollll
- Forum Contributor
- Posts: 181
- Joined: Tue Jun 10, 2003 11:56 pm
- Location: Round Rock, TX
- Contact:
Try using:
Code: Select all
SELECT SUM(column_name) FROM table_name;