Skip to content
Related Articles

Related Articles

How to Compute the Sum of All Rows of a Column of a MySQL Table Using Python?
  • Last Updated : 26 Nov, 2020

MySQL server is an open-source relational database management system that is a major support for web-based applications. Databases and related tables are the main component of many websites and applications as the data is stored and exchanged over the web. In order to access MySQL databases from a web server, we use various modules in Python such as PyMySQL, mysql.connector, etc. 

In this article, we are going to Compute the Sum of All Rows of a Column in a specific MySQL table in a Database. First, we are going to connect to a database having a MySQL table. The SQL query that is going to be used is:

SELECT SUM(column_name) FROM table_name

And finally, display the sum of rows in the table.

Below are some programs which depict how to compute the sum of all rows of a column of a MySQL table in a Database:

Example 1



Below is the table student in database gfg which is going to be accessed by a Python script:

Below is the program to get the sum of rows of a particular column in a MySQL table:

Python3

filter_none

edit
close

play_arrow

link
brightness_4
code

# import required module
import mysql.connector
  
# connect python with mysql with your hostname, 
# database, user and password
db = mysql.connector.connect(host='localhost',
                             database='gfg',
                             user='root',
                             password='')
  
# create cursor object
cursor = db.cursor()
  
# get the sum of rows of a column
cursor.execute("SELECT SUM(Marks) FROM student")
  
# fetch sum and display it
print(cursor.fetchall()[0][0])
  
# terminate connection
db.close()

chevron_right


Output:

Example 2

Here is another example to get the sum of rows from a table in a given database, below is the table schema and rows:



Below is the python script to get row sum of members from the table club:

Python3

filter_none

edit
close

play_arrow

link
brightness_4
code

# import required module
import mysql.connector
  
# connect python with mysql with your hostname, 
# database, user and password
db = mysql.connector.connect(host='localhost',
                             database='gfg',
                             user='root',
                             password='')
  
# create cursor object
cursor = db.cursor()
  
# get the sum of rows of a column
cursor.execute("SELECT SUM(members) FROM club")
  
# fetch sum and display it
print(cursor.fetchall()[0][0])
  
# terminate connection
db.close()

chevron_right


Output:


Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.

To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course.

My Personal Notes arrow_drop_up
Recommended Articles
Page :