Delete data from mysql using Python programming language

Python supports various databases and allows easy integration of database queries and transactions within Python programs. In this tutorial, we will dive into the process of deleting data from a MySQL database using Python programming language. You will learn how to establish a connection with a MySQL database, write SQL queries to delete data from a table, and execute those queries using Python. 

How to delete data from table in MySQL with Python :

• Follow the steps given below to delete data from table in MySQL with python 
  • Step 1: Install the required Packages
  • Step 2: Establishing a Connection to the MySQL Server
  • Step 3: Create a Cursor Object
  • Step 4: delete data from table
  • Step 5: Commit the changes

Step 1: Install the Required Packages

• The first step is to ensure that you have installed the required packages on your machine.
• The most popular packages for connecting to MySQL in Python are 
  • mysql-connector and 
  • PyMySQL.
• You can install these packages using pip through the command line.
• Code Sample :

!pip install mysql-connector-python
!pip install PyMySQL

Step 2: Connect to the MySQL Database

• To create a new database in MySQL using Python, we must have a connection to the MySQL server.
• To connect to a MySQL server in Python we can use either 
  • mysql.connector or 
  • PyMySQL package 
• We need to provide the necessary connection parameters to establish the connection.
• We need to pass the following parameters to the Connection object: 
  • host : the hostname  of the MySQL server user 
  • user : username for the MySQL account
  • password : password for the MySQL account database
  • database : The name of the database to connect to 
• To study package specific code for connecting to MySQL read our tutorial on connecting to MySQL server.

Step 3: Create a Cursor Object

• After establishing a connection to the MySQL server, your next step is to create a cursor object.
• This is done using the cursor() method provided by mysql.connector or PyMySQL.
• Code Sample :

cursor = mydb.cursor()

Step 4: Delete data from table

• To delete data from a MySQL table using Python, use the  DELETE FROM  statement.
• Use the  execute()  method on the cursor object to execute the query.
• Code Sample :

query = "DELETE FROM employees WHERE id = %s"
values = (1,)
cursor.execute(query, values)

Step 5: Commit the changes

• Finally, make sure to commit the changes to the MySQL table 
• This can be done using the commit() method provided by mydb.
• Code Sample :

mydb.commit()

#Print message to confirm changes
print("Changes successfully saved to the database!")