How to sum multiple columns in mysql

In mysql, you can use the sum() function to perform multi-column sums. This function can return the total number of numerical columns. The syntax is "SELECT SUM(Column 1 Column 2 Column 3...) FROM table_name; ".

The operating environment of this tutorial: windows10 system, mysql8.0.22 version, Dell G3 computer.

How to sum multiple columns in mysql

The SUM() function returns the total number of numeric columns.

SQL SUM() syntax

SELECT SUM(column_name) FROM table_name;

Demo database

In this tutorial, we will use the RUNOOB sample database.

The following is the data selected from the "access_log" table:

mysql> SELECT * FROM access_log;
+-----+---------+-------+------------+
| aid | site_id | count | date       |
+-----+---------+-------+------------+
|   1 |       1 |    45 | 2016-05-10 |
|   2 |       3 |   100 | 2016-05-13 |
|   3 |       1 |   230 | 2016-05-14 |
|   4 |       2 |    10 | 2016-05-14 |
|   5 |       5 |   205 | 2016-05-14 |
|   6 |       4 |    13 | 2016-05-15 |
|   7 |       3 |   220 | 2016-05-15 |
|   8 |       5 |   545 | 2016-05-16 |
|   9 |       3 |   201 | 2016-05-17 |
+-----+---------+-------+------------+
9 rows in set (0.00 sec)

SQL SUM() Example

The following SQL statement searches for the "count" field of the "access_log" table Total:

Examples

SELECT SUM(count) AS nums FROM access_log;

2. Statistics of the total scores of all lecturers

Example grammar As follows:

Recommended learning: mysql video tutorial

The above is the detailed content of How to sum multiple columns in mysql. For more information, please follow other related articles on the PHP Chinese website!