python mysql delete

To delete data from a MySQL database using Python, you can modify the SQL DELETE statement that you execute using the "mysql-connector-python" library. Here are the steps to delete data from a MySQL database using Python:

Install the mysql-connector-python library using pip. You can use the following command to install it:

pip install mysql-connector-python

Import the mysql.connector module in your Python script. You can do this using the following code:

import mysql.connector

Establish a connection to your MySQL server using the mysql.connector.connect() method. This method takes several parameters, including the host name, user name, password, and database name. Here is an example:

mydb = mysql.connector.connect(
 host="localhost",
 user="yourusername",
 password="yourpassword",
 database="mydatabase"
)

Once you have established a connection, you can create a new cursor object using the connection object and execute an SQL DELETE statement to delete data from a table. Here is an example:

mycursor = mydb.cursor()
sql = "DELETE FROM customers WHERE address = %s"
val = ("Highway 21", )
mycursor.execute(sql, val)
mydb.commit()
print(mycursor.rowcount, "record(s) deleted")

In this example, we are deleting all the data from a "customers" table where the "address" column is equal to "Highway 21". We use the %s placeholder syntax to insert the WHERE condition into the SQL statement, and pass the actual value in a tuple to the execute() method. After executing the SQL statement, we commit the changes using the commit() method of the connection object. Finally, we print out the number of records that were deleted.

The complete Python code to delete data from a MySQL database using mysql-connector-python would look like this:

import mysql.connector
mydb = mysql.connector.connect(
 host="localhost",
 user="yourusername",
 password="yourpassword",
 database="mydatabase"
)
mycursor = mydb.cursor()
sql = "DELETE FROM customers WHERE address = %s"
val = ("Highway 21", )
mycursor.execute(sql, val)
mydb.commit()
print(mycursor.rowcount, "record(s) deleted")

In this code, you will need to replace "yourusername" and "yourpassword" with the actual values for your MySQL server, and "mydatabase" with the name of your database. Once you run this code, it will delete all the data from the "customers" table where the "address" column is equal to "Highway 21", and print out the number of records that were deleted.