Deleting Element from Table in MySql using Python
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 databaseimport 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 databaseimport 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:
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
