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 databaseimportmysql.connectormydb=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 databaseimportmysql.connectormydb=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:
