Retrieving Entries from a MySQL Database

Retrieving Entries from a MySQL Database : MySQL : Database PYTHON TUTORIALS

PYTHON TUTORIALS » Database » MySQL »

Retrieving Entries from a MySQL Database


import MySQLdb

myDB = MySQLdb.connect(host="127.0.0.1", port=3306, db="schedule")

cHandler = myDB.cursor()

sqlCommand = "SELECT * FROM Arrivals WHERE city = 'Dallas'"
cHandler.execute(sqlCommand)

results = cHandler.fetchall()
print results

sqlCommand = "SELECT * FROM Arrivals"
cHandler.execute(sqlCommand)

results = cHandler.fetchall()
print results

cityList = []
flightList = []
timeList = []
for row in results:
    cityList.append(row[0])
    flightList.append(row[1])
    timeList.append(row[2])

x = 0
for flight in flightList:
    print ("Flight %s arrives from %s at %s" % (flight, cityList[x],  timeList[x]))
    x+=1

myDB.close()