Find out how to Replace a MySQL Desk in Python

First, you will have the mysql.connector. If you’re not sure of the way to get this setup, seek advice from Find out how to Set up MySQL Driver in Python.

Find out 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 tackle = 'Stoneleigh Place' WHERE tackle = 'Abbey Street'"
mycursor.execute(sql)
mydb.commit()

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

Forestall 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 tackle = %s WHERE tackle = %s"
val = ("Stoneleigh Place", "Abbey Street")

mycursor.execute(sql, val)
mydb.commit()

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