# import MySQL module import MySQLdb # get user input name = raw_input("Please enter a name: ") species = raw_input("Please enter a species: ") # connect db = MySQLdb.connect(host="localhost", user="joe", passwd="secret",db="db56a") # create a cursor cursor = db.cursor() # execute SQL statement cursor.execute("INSERT INTO animals (name, species) VALUES (%s, %s)",(name, species)) # import MySQL module import MySQLdb # connect db = MySQLdb.connect(host="localhost", user="joe", passwd="secret",db="db56a") # create a cursor cursor = db.cursor() # execute SQL statement cursor.execute("""INSERT INTO test (field1, field2) VALUES ("val1","val2")""") # get ID of last inserted record print "ID of inserted record is ", int(cursor.insert_id()) # import MySQL module import MySQLdb # connect db = MySQLdb.connect(host="localhost", user="joe", passwd="secret",db="db56a") # create a cursor cursor = db.cursor() # dynamically generate SQL statements from list cursor.executemany("INSERT INTO animals (name, species) VALUES (%s,%s)", [('Rollo', 'Rat'), ('Dudley', 'Dolphin'), ('Mark', 'Marmoset')]) # import MySQL module import MySQLdb # initialize some variables name = "" data = [] # loop and ask for user input while (1): name = raw_input("Please enter a name (EOF to end): ") if name == "EOF": break species = raw_input("Please enter a species: ") # put user input into a tuple tuple = (name, species) # and append to data[] list data.append(tuple) # connect db = MySQLdb.connect(host="localhost", user="joe", passwd="secret",db="db56a") # create a cursor cursor = db.cursor() # dynamically generate SQL statements from data[] list cursor.executemany("INSERT INTO animals (name, species) VALUES (%s,%s)",data)