python&mysql的一个例子

import MySQLdb

name = ""
data = []

while (1):
 name = raw_input("Please enter a name (EOF to end): ")
 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)