The right way to Replace a MySQL Desk in Python

First, you have to the mysql.connector. In case you are uncertain of methods to get this setup, discuss with The right way to Set up MySQL Driver in Python.

The right way to Replace a MySQL Desk in Python

import mysql.connector

mydb = mysql.connector.join(
  host = "localhost",
  person = "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, "report(s) affected")

Forestall SQL Injection in your Replace Clause in Python

import mysql.connector

mydb = mysql.connector.join(
  host = "localhost",
  person = "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, "report(s) affected")