Methods to Delete MySQL Data in Python

First, you’ll need the mysql.connector. In case you are uncertain of how one can get this setup, discuss with Methods to Set up MySQL Driver in Python.

Methods to Delete MySQL Data in Python

import mysql.connector

mydb = mysql.connector.join(
  host = "localhost",
  consumer = "username",
  password = "YoUrPaSsWoRd",
  database = "your_database"
)

mycursor = mydb.cursor()
sql = "DELETE FROM prospects WHERE deal with = 'The Rockies'"
mycursor.execute(sql)

mydb.commit()

print(mycursor.rowcount, "report(s) deleted")

Stop SQL Injection in MySQL queries via Python

Specify the injected variable because the second argument to the execute command as under.

import mysql.connector

mydb = mysql.connector.join(
  host = "localhost",
  consumer = "username",
  password = "YoUrPaSsWoRd",
  database = "your_database"
)

mycursor = mydb.cursor()

sql = "DELETE FROM prospects WHERE deal with = %s"
adr = ("The Rockies", )

mycursor.execute(sql, adr)

mydb.commit()

print(mycursor.rowcount, "report(s) deleted")