How to Search Records from Database Table using PDBC

Program 1

import MySQLdb
from MySQLdb import *
try:
    con=MySQLdb.Connect(host="localhost",user="root",password="root",database="dataflair")
    print("Connection Success")
    sql="select * from employee"
    cur=con.cursor()
    cur.execute(sql)
    result=cur.fetchall()
    print("----------------------------------------------------------------")
    print("ID         NAME       DEPARTMENT     SALARY")
    for row in result:
        print("%d        %s           %s           %d" %(row[0],row[1],row[2],row[3]))
        print("-------------------------------------------------------------")
except Exception as obj:
    print(obj)
finally:
    con.close()