Open In App

Deleting Element from Table in MySql using Python

Improve
Improve
Like Article
Like
Save
Share
Report

Prerequisite: Python: MySQL Create Table

In this article, we are going to see how to get the size of a table in MySQL 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. 

Approach:

  • Import module.
  • Make a connection request with the database.
  • Create an object for the database cursor.
  • Execute the following MySQL query:
DELETE FROM TABLE_NAME  WHERE Column Name = 'Value';

Example 1:

In this example we are using this database table with the following query;

Below is the implementation:

Python3




# Establish connection to MySQL database
import mysql.connector
  
mydb = mysql.connector.connect(
  host="localhost",
  user="root",
  password="root123",
  database = "geeks"
  )
mycursor = mydb.cursor()
  
query = " DELETE FROM EMPLOYEE  WHERE INCOME = '5000';"
mycursor.execute(query)
mydb.commit()
  
print(mycursor.rowcount, "record(s) deleted")
mydb.close()


Output:

1 record(s) deleted

After deleting the element our table looks like this:

Example 2:

In this example we are going to delete the same table with a different column name:

Python3




# Establish connection to MySQL database
import mysql.connector
  
mydb = mysql.connector.connect(
  host="localhost",
  user="root",
  password="root123",
  database = "geeks"
  )
mycursor = mydb.cursor()
  
query = " DELETE FROM EMPLOYEE  WHERE LAST_NAME = 'Mohan';"
mycursor.execute(query)
mydb.commit()
  
print(mycursor.rowcount, "record(s) deleted")
mydb.close()


Output:

1 record(s) deleted

After deleting the element our table looks like this:



Last Updated : 03 Jan, 2021
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads