IMPORT MySQLDB
Name = "" DATA = []
While (1): name = Raw_Input ("please enter a name:") if Name == "EOF": Break Species = Raw_INPUT ("please enter a species:") TUPLE = (Name, Species) Data.append (tuple) DB = mysqldb.connect (Host = 'localhost', user = 'joe', passwd = 'security', db = 'db56a') CURSOR = db.cursor () Cursor.execUtemany ("Insert Into Animals (Name, Species) VALUES (% s,% s) ", DATA)
