/Doc/includes/sqlite3/execsql_printall_1.py
http://unladen-swallow.googlecode.com/ · Python · 13 lines · 5 code · 4 blank · 4 comment · 0 complexity · f65453c779fa367dd7bbbda49610975c MD5 · raw file
- 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()