Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 34 of 43

Practice Paper — Question 5

Back to all questions
5
Question

Question 29(a)

Consider the following table STUDENT.

NONAMEAGEDEPARTMENTFEESEX
1PANKAJ24COMPUTER120M
2SHALINI21HISTORY200F
3SANJAY22HINDI300M
4SUDHA25HISTORY400F

Write a Python code to search a record as per given NO (number) using MySQL connectivity and print the data.

Solution
import mysql.connector
mydb = mysql.connector.connect(host = "localhost", 
                                user = "root", 
                                passwd = "tiger", 
                                database = "kboat_cbse_12")
mycursor = mydb.cursor()
NO = int(input("Enter the number to search: "))
mycursor.execute("SELECT * FROM STUDENT WHERE NO = {}".format(NO))
myrecord = mycursor.fetchone()
if myrecord != None:
    print(myrecord)
else:
    print("No such student found")
Output
Enter the number to search: 2
(2, 'SHALINI', 21, 'HISTORY', 200, 'F')
Answer