The way to Delete MySQL Data in Python

First, you have to the mysql.connector. If you’re uncertain of how you can get this setup, discuss with The way to Set up MySQL Driver in Python.

The way to 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 means of Python

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

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")