How to Fetch All Record From Database

Program 1

# Program for Select data(search) 
import MySQLdb
try:
    con=MySQLdb.connect(host='localhost',user='root',password='root',database='DataFlair')   
    #print("Data Base connected")
    sql="select * from employee"
    cur=con.cursor()
    cur.execute(sql)
    result=cur.fetchall()
    print("------------------------------------------")
    print("Emp Id\t Emp Name\t Mobile\t Age")
    print("------------------------------------------")
    for row in result:
        print("%d\t %s\t        %d\t  %d" %(row[0],row[1],row[2],row[3]))
    print("------------------------------------------")
except Exception as obj:
    print(obj)    
finally:
    con.close()