question

Philosophaie avatar image
Philosophaie asked

Simple SUM question

A simple question. I have a table called counter. It has a column called count_riseset. I would like to sum all of the cells in the column. This seems not to be not working. SELECT SUM(count_riseset) FROM counter
mysqlsum
4 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Dave_Green avatar image Dave_Green ♦ commented ·
What error message do you get? My first thought is - what is the data type of count_riseset?
1 Like 1 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
data type? how many rows? What are the approximate values? What's the error message?
0 Likes 0 ·
Philosophaie avatar image Philosophaie commented ·
Data type INT(5) 25rows No error accounting methods used.
0 Likes 0 ·
Philosophaie avatar image Philosophaie commented ·
Using MySQL used INSERT INTO to insert 25 rows of data. Just need the right SUM command to work with all the rows.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.