How to Delete Records From an Existing Table in Python MySQL

In this example we will show how to delete records from an existing table in Python MySQL.

Source Code

import mysql.connector

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

mycursor = mydb.cursor()

sql = "DELETE FROM us_state WHERE Capital = 'Phoenix'"

mycursor.execute(sql)

mydb.commit()

print(mycursor.rowcount, "record was deleted.")

# close the connection
mydb.close()

Output:

1 record was deleted.