import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="root",
passwd="aimtocode",
database="mydatabase"
)
mycursor = mydb.cursor()
sql = "UPDATE customers SET address = 'Rocky' WHERE address = 'Prayag'"
mycursor.execute(sql)
mydb.commit()
print(mycursor.rowcount, "record successfully updated.")