17 lines · 475 B · Python
RawDownload
import sqlite3 con = sqlite3.connect("mydb") cur = con.cursor()SELECT = "select name_last, age from people order by age, name_last" # 1. Iterate over the rows available from the cursor, unpacking the# resulting sequences to yield their elements (name_last, age):cur.execute(SELECT)for (name_last, age) in cur:    print '%s is %d years old.' % (name_last, age) # 2. Equivalently:cur.execute(SELECT)for row in cur:    print '%s is %d years old.' % (row[0], row[1])