Design a Python application that fetches all the records from Pet table of menagerie database.

Q. Design a Python application that fetches all the records from Pet table of menagerie database.

Answer = 

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

cur = mydb.cursor()
run = "select * from PET "
cur . execute(run)
data  = cur.fetchall()
for i in data :
    print(i)

mydb.close()