How you can Delete MySQL Data in Python

First, you have to the mysql.connector. In case you are uncertain of tips on how to get this setup, consult with How you can Set up MySQL Driver in Python.

How you can Delete MySQL Data in Python#

import mysql.connector

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

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

mydb.commit()

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

Stop SQL Injection in MySQL queries by way of Python#

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

import mysql.connector

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

mycursor = mydb.cursor()

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

mycursor.execute(sql, adr)

mydb.commit()

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