cinap_lenrekadd hg and python4bb9e2215 years agoHistory
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])

Keyboard shortcuts

General

Show keyboard shortcuts
?
Focus the current search
/

Issues and pull requests

Open filters
f

Issues, pull requests and Inbox

Select next item
j↓
Select previous item
k↑
Open selected item
Enter
Dismiss filters or clear selection
Esc

Repository code

Go to file
t