SELECT*FROMemployee_tbl;+------+------+-------- ----+--------------------+|id |name|work_date |daily_typing_pages|+------+------+ ------------+--------------"> How do we use MySQL SUM() function?-Mysql Tutorial-php.cn
简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home> Database> Mysql Tutorial> body text

How do we use MySQL SUM() function?

PHPz
Release： 2023-09-05 11:53:12
forward
679 people have browsed it

我们如何使用 MySQL SUM() 函数？

#MySQL SUM function is used to calculate the sum of a field in multiple records. To understand the SUM() function, consider an "employee_tbl" table which has the following records -

mysql> SELECT * FROM employee_tbl; +------+------+------------+--------------------+ | id | name | work_date | daily_typing_pages | +------+------+------------+--------------------+ | 1 | John | 2007-01-24 | 250 | | 2 | Ram | 2007-05-27 | 220 | | 3 | Jack | 2007-05-06 | 170 | | 3 | Jack | 2007-04-06 | 100 | | 4 | Jill | 2007-04-06 | 220 | | 5 | Zara | 2007-06-06 | 300 | | 5 | Zara | 2007-02-06 | 350 | +------+------+------------+--------------------+ 7 rows in set (0.00 sec)
Copy after login

Now, assuming based on the above table you want to count the total number of all dialy_typing_pages, then you can use the following command to Complete-

mysql> SELECT SUM(daily_typing_pages) -> FROM employee_tbl; +-------------------------+ | SUM(daily_typing_pages) | +-------------------------+ | 1610 | +-------------------------+ 1 row in set (0.00 sec)
Copy after login

The above is the detailed content of How do we use MySQL SUM() function?. For more information, please follow other related articles on the PHP Chinese website!

source：tutorialspoint.com
Previous article：How to get the last day of next month in MySQL? Next article：How to use 2-digit year value in MySQL DATEDIFF() function?
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
2
1297
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
9
1394
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1228
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1133
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1204
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！