Update Table
You can update existing records by using Update statement.
import mysql.connector mycon = mysql.connector.connect( host="localhost", user="root", passwd="1234", database="college" ) mycur = mycon.cursor() mycur.execute("UPDATE students SET address = 'Varanasi' WHERE address = 'Lucknow'") mycon.commit() print(mycur.rowcount, "record(s) affected")
Output
C:\Users\My Name>python demo.py 1 record(s) affected