10-06_db_show_record.py

#10-06_db_connectivity
#Mysql - Python connectivity

import mysql.connector as con

mydb=con.connect(host='localhost', user='root', passwd='pankaj', database='xibtp')
mycursor=mydb.cursor()
sql='select admno, name, sex, class, sec  from student where admno=9046'
mycursor.execute(sql)                   #executing SQL
myresult = mycursor.fetchall()          #fetching data from db
for data in myresult:
    print(data)
mydb.close()