Question

The code given below reads the following record from the table named student and displays only those records that have marks greater than 75:

• RollNo - integer
• Name - string
• Clas - integer
• Marks - integer

Note the following to establish connectivity between Python and MYSQL:

• Username is root.
• The password is the tiger.
• The table exists in an MYSQL database named school.

Write the following missing statements to complete the code:

Statement 1 - to form the cursor object
Statement 2 - to execute the query that extracts records of those students whose marks are greater than 75.
Statement 3 - to read the complete result of the query (records whose marks are greater than 75) into the object named data, from the table student in the database.

import mysql.connector as mysql
def sql_data():
       con1=mysql.connect(host="localhost",user="root",password="tiger", database="school")
       mycursor=_______________ #Statement 1
       print("Students with marks greater than 75 are :")
                  _________________________ #Statement 2
                 data=__________________ #Statement 3
                for i in data:
                   print(i)
                print()

Answer 1

Statement 1:
con1.cursor()

Statement 2:
mycursor.execute("select * from student where Marks>75")

Statement 3:
mycursor.fetchall()