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 delete:"))
mycursor.execute("delete from sunny where id=%s",(id))
print(f" record with id {id} deleted successfully")
mydb.commit()
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