统计mysql表中特定行的数据

Question

您好，我如何计算 mysql 表的特定列中的整数？

+------------+--------+
| product_id | stores |
+------------+--------+
|     371374 |      1 |
|     283994 |      1 |
|     232191 |      2 |
|     131127 |      1 |
|     284000 |      1 |
|     371383 |      1 |
|         83 |      3 |
|     131156 |      1 |
|     371385 |      1 |
|     284004 |      1 |
+------------+--------+

我想计算所有商店，例如 1 + 1 + 2 + 1 + ...

Answer 1

从表名中选择 SUM（存储）

Answer 2

尝试：

SELECT SUM(stores) 
  FROM mytable

Answer 3

尝试这个查询

select sum(stores) from <tablename>;

Answer 4

SELECT SUM( stores ) AS sum
FROM `table_name`