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