MySQL:如何优化字段求和的结果？

Question

我有这样的疑问：

SELECT name, SUM(count_1 + count_2 + count_3 + count_4 + count_5 + count_6) AS Total
FROM my_table

有没有办法将这些值与count_1 + count_2 + count_3 + count_4 + count_5 + count_6相加，等等。更高效？当我添加大量字段时，MySQL总是崩溃。

Answer 1

无论db设计是否正确，如果使用聚合函数，都应该使用group by。

SELECT name, SUM(count_1 + count_2 + count_3 + count_4 + count_5 + count_6) AS Total
FROM my_table
GROUP BY name