Skip to content
Related Articles

Related Articles

Python MySQL – Where Clause

View Discussion
Improve Article
Save Article
  • Difficulty Level : Medium
  • Last Updated : 23 Jan, 2022
View Discussion
Improve Article
Save Article

Where clause is used in MySQL database to filter the data as per the condition required. You can fetch, delete or update a particular set of data in MySQL database by using where clause.
Syntax
 

SELECT column1, column2, …. columnN FROM [TABLE NAME] WHERE [CONDITION]; 
 

The above syntax is used for displaying a certain set of data following the condition.
Example: Consider the following database named college and having a table name as a student.
Schema of the database:
 

python-db-schema

  
Database:
 

python-db-table

  
 

Where Clause In Python

Steps to use where clause in Python is: 
 

  1. First form a connection between MySQL and Python program. It is done by importing mysql.connector package and using mysql.connector.connect() method, for passing the user name, password, host (optional default: localhost) and, database (optional) as parameters to it.
  2. Now, create a cursor object on the connection object created above by using cursor() method. A database cursor is a control structure that enables traversal over the records in a database.
  3. Then, execute the where clause statement by passing it through execute() method.

 

Python3




import mysql.connector
  
#Establishing connection
conn = mysql.connector.connect(user='your_username',
                               host='localhost',
                               password ='your_password',
                               database='College')
  
# Creating a cursor object using
# the cursor() method
mycursor = conn.cursor();
  
# SQL Query
sql = "select * from Student where Roll_no >= 3;"
  
# Executing query
mycursor.execute(sql)
  
myresult = mycursor.fetchall()
  
for x in myresult:
    print(x)
 
# Closing the connection
conn.close()

OUTPUT: 
 

python-where-mysql

 

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!