• Source 
    1. import mysql.connector
    2.  
    3. mydb = mysql.connector.connect(
    4.   host="localhost",
    5.   user="myusername",
    6.   passwd="mypassword",
    7.   database="mydatabase"
    8. )
    9.  
    10. mycursor = mydb.cursor()
    11.  
    12. sql = "UPDATE customers SET address = %s WHERE address = %s"
    13. val = ("Valley 345", "Canyon 123")
    14.  
    15. mycursor.execute(sql, val)
    16.  
    17. mydb.commit()
    18.  
    19. print(mycursor.rowcount, "record(s) affected")
    20.