import sys
import MySQLdb

conn = MySQLdb.connect (host = "localhost", user = "testuser", passwd = "testpass", db = "test")

cursor = conn.cursor ()
cursor.execute ("DROP TABLE IF EXISTS test")

cursor.execute (""" CREATE TABLE test (name CHAR(40), category CHAR(40)) """)

cursor.execute (""" INSERT INTO test (name, category) VALUES ('snake', 'reptile'), ('frog','amphibian'), ('tuna', 'fish'), ('racoon', 'mammal') """)

print "Number of rows inserted: %d" % cursor.rowcount

raw_input("")

cursor.execute ("SELECT name, category FROM test")
while (1):
     row = cursor.fetchone ()
     if row == None:
           break
     print "%s, %s" % (row[0], row[1])
print "Number of rows returned: %d" % cursor.rowcount

raw_input("")

cursor.close()
conn.commit()
conn.close()