/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

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