First, you have to the mysql.connector. In case you are uncertain of learn how to get this setup, confer with Learn how to Set up MySQL Driver in Python.
Learn how to Replace a MySQL Desk in Python
import mysql.connector
mydb = mysql.connector.join(
host = "localhost",
consumer = "username",
password = "YoUrPaSsWoRd",
database = "your_database"
)
mycursor = mydb.cursor()
sql = "UPDATE clients SET deal with = 'Stoneleigh Place' WHERE deal with = 'Abbey Highway'"
mycursor.execute(sql)
mydb.commit()
print(mycursor.rowcount, "file(s) affected")
Stop SQL Injection in your Replace Clause in Python
import mysql.connector
mydb = mysql.connector.join(
host = "localhost",
consumer = "username",
password = "YoUrPaSsWoRd",
database = "your_database"
)
mycursor = mydb.cursor()
sql = "UPDATE clients SET deal with = %s WHERE deal with = %s"
val = ("Stoneleigh Place", "Abbey Highway")
mycursor.execute(sql, val)
mydb.commit()
print(mycursor.rowcount, "file(s) affected")
