Python MySQL
MySQL Update
Updating data
MySQL Update
You can update existing records in a table by using the "UPDATE" statement.
Update Record
sql = "UPDATE customers SET address = 'Canyon 123' WHERE address = 'Valley 345'"
mycursor.execute(sql)
mydb.commit()