| 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()) | |
| con.close() |