import mysql.connector as c mydb = c.connect( host="localhost", user="root", password="1234", database="cvr" ) mycursor = mydb.cursor() id=int(input("Enter the student id to update:")) updated_name=input("Enter the updated name: ") mycursor.execute("update sunny set name=%s where id=%s",(updated_name,id)) mydb.commit() print("record updated successfully")
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter