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