First page Back Continue Last page Overview Graphics

Selecting a Information

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()