Adding Entries to a MySQL Database

Adding Entries to a MySQL Database : MySQL : Database PYTHON TUTORIALS

PYTHON TUTORIALS » Database » MySQL »

Adding Entries to a MySQL Database


import MySQLdb

cities = ["Dallas", "Los Angeles", "New York"]
flights = ["1144", "1045", "1520"]
times = ["230pm", "320pm", "420pm"]

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

cHandler = myDB.cursor()

x = 0
for city in cities:
    sqlCommand = "INSERT INTO Arrivals VALUES('%s', '%s', '%s')" % (city, flights[x], times[x])
    cHandler.execute(sqlCommand)
    x += 1

sqlCommand = "SELECT cities, flights, times FROM Arrivals"
cHandler.execute(sqlCommand)
results = cHandler.fetchall()
print results

myDB.commit()

myDB.close()