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!