Class 12th CBSE CS

Write a Code to update Data in MYSQL from Python.

Solution: –

import mysql.connector as cn
s = cn.connect(
    host = "localhost",
    user = "root",
    passwd = "root",
    database = "bank",
    auth_plugin="mysql_native_password")
mycursor = s.cursor()
sql = "UPDATE customers SET address = 'Surat' WHERE address = 'Vesu'"
mycursor.execute(sql)
s.commit()
print(mycursor.rowcount, "record(s) affected")