1
2
3
4
5
6
7
8
9
10
11
12
13
| import sqlite3
|
| # Create a connection to the database file "mydb":
| con = sqlite3.connect("mydb")
|
| # Get a Cursor object that operates in the context of Connection con:
| cur = con.cursor()
|
| # Execute the SELECT statement:
| cur.execute("select * from people order by age")
|
| # Retrieve all rows as a sequence and print that sequence:
| print(cur.fetchall())
|
|
