Design a Python application that fetches only those records from Event table of menagerie database where type is Kennel.

Q. Design a Python application that fetches only those records from Event table of menagerie database where type is Kennel.

Answer = 

import mysql.connector as a
mydb = a.connect(host="localhost",user="root",password="portal express", database = "menagerie")

cur = mydb.cursor()
run = "select * from Event where type = 'Kennel'  "
cur . execute(run)
data  = cur.fetchall()
for i in data :
    print(i)

mydb.close()