|
||
Welcome to CS-IP LabUpdates:
Python with MySQL data display
import mysql.connector as con
db=con.connect(host='localhost', user='root', passwd='', database='dkm')
cur=db.cursor()
cur.execute("select * from prods")
tb=cur.fetchall()
#a=input("Enter pid to find : ")
print("|%5s | %10s | %10s |"%('PID','Name','Co.'))
print("___________________________________________")
for r in tb:
print("|%5s | %10s | %10s |"%(r[0],r[1],r[3]))
print("___________________________________________")
Links: Annual Day Video Draft (13GB) SHI Demo Test MYSQL practice 1 RP video Downloads: AI 10 Practical File Class XI - IP sample QP MySQL Assignment for class XI, XII (CS,IP) Project Report Format Python PPT from IIT | ||