/usr/web/sources/contrib/jas/root/sys/src/cmd/cpython/Doc/includes/sqlite3/execute_3.py

Plan 9 from Bell Labs’s /usr/web/sources/contrib/jas/root/sys/src/cmd/cpython/Doc/includes/sqlite3/execute_3.py


import sqlite3

con = sqlite3.connect("mydb")

cur = con.cursor()

who = "Yeltsin"
age = 72

cur.execute("select name_last, age from people where name_last=:who and age=:age",
    locals())
print cur.fetchone()

(Return to Plan 9 Home Page)