MySQL Delete

At some point in your journey as a Python developer, you will come across the need to delete data from a MySQL database. This may seem like a daunting task, but with Python and MySQL, it can be done easily and quickly. In this article, we will show you how to delete data from a MySQL database using Python.

Prerequisites

Before we begin, there are a few things you will need:

• Python installed on your computer
• MySQL installed on your computer
• A database created in MySQL
• Python MySQL Connector module installed

Connecting to the MySQL Database

The first step in deleting data from a MySQL database using Python is connecting to the database. To do this, we will use the Python MySQL Connector module.

import mysql.connector

#establishing the connection
conn = mysql.connector.connect(user='your_username', password='your_password',
                              host='localhost',
                              database='your_database')

Creating a Cursor Object

Once we have established a connection to the database, we need to create a cursor object. The cursor object is what we use to execute SQL queries on the database.

#create a cursor object
cursor = conn.cursor()

Deleting Data from the Database

Now that we have established a connection and created a cursor object, we can proceed with deleting data from the MySQL database.

#delete a record from the table
sql = "DELETE FROM table_name WHERE column_name = %s"
val = ("value",)

cursor.execute(sql, val)

#commit the transaction
conn.commit()

print(cursor.rowcount, "record(s) deleted")

In the above example, we delete a record from a table named "table_name" where the value in the "column_name" is equal to "value". The cursor.rowcount method returns the number of records that were deleted.

Closing the Connection

Once we have finished deleting data from the MySQL database, we need to close the connection.

#close the cursor and connection objects
cursor.close()
conn.close()

Conclusion

In this article, we have shown you how to delete data from a MySQL database using Python. We started by establishing a connection to the database, creating a cursor object, and then deleting data from the database using the cursor object. Finally, we closed the connection to the database. With this knowledge, you can easily delete data from a MySQL database using Python and take your Python skills to the next level.