How do you iterate over a result set of data?

curs.execute("select * from people")
for row in curs:
    print row

for row in curs.fetchall():
    print row

curs.execute("select first_name from people")
names = [row[0] for row in curs.fetchall()]

curs.execute("select max(x) from t")
maxValue = curs.fetchone()[0]

row = curs.fetchone()
while row:
    print row
    row = curs.fetchone()

Source: By Mark Harrison as answer to the question

This code snippet was collected from stackoverflow, and is licensed under CC BY-SA 3.0

code-tutorial.com