while True:
    print("!!!!STUDENT RECORD KEEPING!!!!!! ")
    print("1.to insert records " )
    print("2.to update records " )
    print("3.to search records " )
    print("4.to see all records " )
    print("5.to delete records " )
    print("6. Press 6 to exit ")
    choice=int(input("Enter your choice "))
    if choice==1:
        import mysql.connector
        mydb=mysql.connector.connect(host="localhost",user="root",passwd="",database="school1")
        mycursor=mydb.cursor()
        rollno=int(input("roll no:"))
        name=input("Enter name(limit 35 characters):")
        age=str(input("Enter age.:"))
        marks=str(input("Enter marks.:"))
        mycursor.execute("insert into student values('"+str(rollno)+"','"+name+"','"+age+"','"+marks+"')")
        mydb.commit()
        print("student data is successfully added!!!")
    

    if choice==2:
        import mysql.connector
        mydb=mysql.connector.connect(host='localhost',user="root",passwd="",database='school1')
        mycursor=mydb.cursor()
        rno=int(input("Enter roll number "))
        mark=input("Enter the new marks ")
        name=input("Enter the name ")
        age=input("Enter the age ")
        mycursor.execute("update student set marks='"+mark+"',"+"name='"+name+"',"+"age='"+age+"'where rollno='"+str(rno)+"'")
        mydb.commit()                 
        print("Record updated successfully")
        

    if choice==3:
        import mysql.connector
        mydb=mysql.connector.connect(host="localhost",user="root",passwd="",database="school1")
        mycursor=mydb.cursor()
        rno=int(input("enter Roll Number "))
        mycursor.execute("select * from student where rollno='"+str(rno)+"'")
        for x in mycursor:
            print (x)
    

    
    if choice==4:
        import mysql.connector
        mydb=mysql.connector.connect(host="localhost",user="root",passwd="",database="school1")
        mycursor=mydb.cursor()
        mycursor.execute("select * from student")
        myrecords=mycursor.fetchall()
        for x in myrecords:
            print (x)


    if choice==5:
        import mysql.connector
        mydb=mysql.connector.connect(host="localhost",user="root",passwd="",database="school1")
        mycursor=mydb.cursor()
        rno=int(input("Enter roll number "))
        mycursor.execute("delete from student where rollno='"+str(rno)+"'")
        mydb.commit()
        print("Record deleted successfully")
    if choice==6:
        break