mysql 统计所有行的总和

mysql count the sum of all rows

提问by med

I have a mysql table that has a number of rows, and in each row a field called "value", the field value will differ from row to row. What I want, is to select all the rows and count the sum of all the "value" fields.

我有一个包含多行的 mysql 表，每行中有一个名为“值”的字段，该字段值会因行而异。我想要的是选择所有行并计算所有“值”字段的总和。

any idea?

任何的想法？

回答by Devin Burke

Do you mean like this?

你的意思是这样吗？

SELECT    SUM(value)
FROM      myTable

If you have multiple columns to return, simply add each non-aggregate (i.e., summed) row to the GROUP BYclause:

如果您有多个要返回的列，只需将每个非聚合（即求和）行添加到GROUP BY子句中：

SELECT    firstName, lastName, SUM(value)
FROM      myTable
GROUP BY  firstName, lastName

回答by Lawrence Cherone

SELECT SUM(value) as total FROM table;

$row['total'];

回答by Tomas Markauskas

SELECT SUM(`value`) FROM `your_table`

回答by Joe Stefanelli

SELECT SUM(value)
    FROM YourTable

回答by Lukas Knuth

What you'll want is the GROUP-function named SUM.

您需要的是GROUP名为SUM的函数。

回答by Amresh

This query will return the sum of valueand the number of rows count:

此查询将返回总和value和行数计数：

SELECT count(*), sum(value) FROM tablename