SQL Insert-Select-Delete statements

 try:

import mysql.connector

import pandas as pd

mydb = mysql.connector.connect(host="localhost",user="root",password="password",database="sem3")

n=mydb.cursor()

while True:

print("Enter 1 for insertion: ")

print("Enter 2 for deletion: ")

print("Enter 3 for seletion")

print("Enter 4 to Exit")

op=int(input("Enter your option:"))

if op==1:

r=int(input("Enter Rollno Number: "))

name=input("Enter Name: ")

p=int(input("Enter Phone Number: "))

stmt="insert into student values {}".format((r,name,p))

n.execute(stmt)

mydb.commit()

elif op==2: 

r=int(input("Enter Rollno Number To bet deleted: "))

stmt="delete from student where idstudent={}".format((r))

n.execute(stmt)

mydb.commit()

elif op==3:

l=mydb.cursor()

l.execute("desc student")

c=l.fetchall()

colname=[]

for t in c:

colname.append(t[0])

l.execute("SELECT * FROM student")

res=l.fetchall()

df=pd.DataFrame(res,columns=colname)

print(df)

elif op==4:

break

except Exception as e:

print(e)