|
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()
|