15+ Interface of Python with MySQL Important Question Answer Class 12 Computer Science Code 083

13. The code given below inserts the following record in the table Student:
Name – string
Gender – string
DOB – date
Stream- string
Marks – integer
Note the following to establish connectivity between Python and MYSQL:
 Username is root
 Password is 123
 The table exists in a MYSQL database named school.
 The details ( Name,Gender,DOB,Stream and Marks) are to be accepted from the user.
Write the following missing statements to complete the code:
Statement 1 – to form the cursor object
Statement 2 – to execute the command that inserts the record in the table Student.
Statement 3- to add the record permanently in the database

import mysql.connector as mysql
def sql_data():
       con1 = mysql.connect(host="localhost",user="root", password="123", database="school")
       mycursor = _____ #Statement 1
       Name=input("Enter name :: ")
       Gender=(input("Enter Gender :: "))
       DOB= (input("Enter Gender :: "))
       Stream=(input("Enter Stream :: "))
       Marks=int(input("Enter Marks :: "))
       querry="insert into student values(„{}‟,'{}',‟{}‟, ‟{}‟,{})".format(Name,Gender ,DOB,Stream,Marks)
       __________ #Statement 2
       __________ # Statement 3
       print("Data Added successfully")

Answer:

Statement 1: con1.cursor()
Statement 2: mycursor.execute(querry)
Statement 3: con1.commit()

14. The code given below inserts the following record in the table Student:
Name – string
Gender – string
DOB – date
Stream- string
Marks – integer
Note the following to establish connectivity between Python and MYSQL:
 Username is root
 Password is 123
 The table exists in a MYSQL database named school.
 The details ( Name,Gender,DOB,Stream and Marks) are to be accepted from the user.
Write the following missing statements to complete the code:
Statement 1 – to form the cursor object
Statement 2 – to execute the querythat extract records of those student whose marks are greater than 90
Statement 3- to read the complete result of the query (records whose marks are greater than 90) 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 = "123", database = "school")
    mycursor=___ #Statement 1
    print("Students with marks greater than 90 are : ")
    _____________ #Statement 2
    data=______ #Statement 3
   for i in data:
        print(i)
    print()

Answer:

Statement 1: con1.cursor( )
Statement 2: mycursor.execute(“select * from student where Marks>75”)
Statement 3: mycursor.fetchall( )

import mysql.connector as mysql
def get_data():
    con1 = mysql.connect(host = "localhost", user = "root", password = "123", database = "STORE")
     mycursor=_____ #Statement 1
     EmpNo = int(input("Enter Employee Number :: "))
     EmpName = input("Enter name :: ")
     EmpDesg = input("Enter employee designation :: ")
     EmpSalary = float(input("Enter Salary :: "))
     query = "insert into student values({},'{}',‟{}‟,{})". format (EmpNo, EmpName, EmpDesig, EmpSalary)
     __________ #Statement 2
     __________ # Statement 3
     print("Data Added successfully")

import mysql.connector as db
mycon = db.connect(host = ”localhost”, user = ”system”,    password = ”test”, database = ”Admin”)
cursor =_______# statement 1
query = ”SELECT * FROM Traders “
__________ # Statement 2
data = ______ # Statement 3
for dt in data:
      print(dt)
mycon.close()