Find out how to Replace a MySQL Desk in Python

First, you have to the mysql.connector. If you’re uncertain of how one can 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 prospects SET handle = 'Stoneleigh Place' WHERE handle = 'Abbey Street'"
mycursor.execute(sql)
mydb.commit()

print(mycursor.rowcount, "document(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 prospects SET handle = %s WHERE handle = %s"
val = ("Stoneleigh Place", "Abbey Street")

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

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