一 代码
import sqlite3
conn=sqlite3.connect(":memory:")
cur=conn.cursor()
cur.execute("CREATE TABLE people(name_last,age)")
who = "cakin"
age = 35
cur.execute("INSERT INTO people VALUES(?,?)",(who,age))
cur.execute("SELECT * FROM people WHERE name_last=:who1 AND age = :age1",
{"who1":who,"age1":age})
print(cur.fetchone())
二 运行结果
==========
('cakin', 35)