Skip to content
Related Articles

Related Articles

Improve Article

Python MariaDB – Delete Query using PyMySQL

  • Last Updated : 14 Oct, 2020

DELETE is an SQL query, that is used to delete one or more entries from a table with a given condition. To connect with MariaDB database server with Python, we need to import pymysql client. After connecting with the database in MySQL we can create tables in it and can manipulate them.

Syntax:

 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. And to begin with your Machine Learning Journey, join the Machine Learning - Basic Level Course

DELETE FROM TABLE_NAME WHERE ATTRIBUTE_NAME = ATTRIBUTE_VALUE

 Example 1: Below is a program to delete a query from the table in the database.



Python3




import pymysql
  
# Create a connection object
# IP address of the MySQL database server
Host = "localhost"  
  
# User name of the database server
User = "user"       
  
# Password for the database user
Password = ""           
  
database = "GFG"
  
conn  = pymysql.connect(host=Host, user=User, 
                        password=Password, database)
  
# Create a cursor object
cur  = conn.cursor()
  
  
query = f"DELETE FROM PRODUCT WHERE PRODUCT_TYPE = 'PRI'"
  
cur.execute(query)
  
# To commit the changes
conn.commit() 
conn.close()

Output :

BeforeAfter

In the above program,  from table PRODUCT a single query is deleted from the table having the PRODUCT_TYPE attribute value PRI.

Example 2: Let us look at another example for queries in a table.

Python3




import pymysql
  
# Create a connection object
conn  = pymysql.connect('localhost', 'user',
                        'password', 'database')
  
# Create a cursor object
cur  = conn.cursor()
  
  
query = f"DELETE FROM PRODUCT WHERE price < 2000"
  
cur.execute(query)
  
# To commit the changes
conn.commit()       
conn.close()

Output :

BeforeAfter

In the above program,  from table PRODUCT a single query is deleted from the table where a price less than 2000.




My Personal Notes arrow_drop_up
Recommended Articles
Page :