Prerequisite: Python: MySQL Create Table
In this article, we are going to see how to get the Minimum and Maximum Value of a Column of a MySQL Table Using Python. Python allows the integration of a wide range of database servers with applications. A database interface is required to access a database from Python. MySQL Connector-Python module is an API in python for communicating with a MySQL database.
Database in use:
We are going to use geeks(Database name) database and table describing the salary.
Approach:
- Import module.
- Make a connection request with the database.
- Create an object for the database cursor.
- Execute the following MySQL query:
SELECT MIN(Column_name) AS minimum FROM Table_name. SELECT MAX(Column_name) AS minimum FROM Table_name.
- And print the result.
Example 1: Getting the minimum value of a column.
Python3
# Establish connection to MySQL database import mysql.connector mydb = mysql.connector.connect( host = "localhost" , user = "root" , password = "root123" , database = "geeks" ) # Create a cursor object cursor = mydb.cursor() # Execute the query cursor.execute( "SELECT MIN(Value) AS minimum FROM salary" ) result = cursor.fetchall() for i in result: maximum = float (i[ 0 ]) print (maximum) # Close database connection mydb.close() |
Output:
200.0
Example 2: Getting the maximum value of a column.
Python3
# Establish connection to MySQL database import mysql.connector mydb = mysql.connector.connect( host = "localhost" , user = "root" , password = "root123" , database = "geeks" ) # Create a cursor object cursor = mydb.cursor() cursor.execute( "SELECT MAX(Value) AS maximum FROM salary" ) result = cursor.fetchall() for i in result: maximum = float (i[ 0 ]) print (maximum) # Close database connection mydb.close() |
Output:
350030.0
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.