Count values in mysql database rows

Question

I have a table in my database that looks like this.

id    count
-----------
1      23
2      20
3      12
4      4

The "count" column will periodically change. How would I add all the values in the count column and display them on the front end? So for example, in this case they would add up to 59.

Did you do any research at all? The MySQL documentation lists all the functions and operators at your disposal; it is obvious in this case which to pick if you peruse it. — Lightness Races in Orbit
– Lightness Races in Orbit, Commented Oct 28, 2011 at 19:32

Joe Stefanelli · Accepted Answer · 2011-10-28 19:33:20Z

3

select sum(count) from table_name

edited Oct 28, 2011 at 19:33

Joe Stefanelli

136k21 gold badges243 silver badges241 bronze badges

answered Oct 28, 2011 at 19:29

Cory Danielson

14.5k4 gold badges47 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Brian Driscoll · Accepted Answer · 2011-10-28 19:29:49Z

0

SELECT SUM(`count`) FROM myTable

answered Oct 28, 2011 at 19:29

Brian Driscoll

19.7k3 gold badges51 silver badges66 bronze badges

Collectives™ on Stack Overflow

Count values in mysql database rows

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related