import sqlite3 as db
conn = db.connect(‘my.db’)
conn.row_factory = lambda cursor, row: row[0]
c = conn.cursor()
ids = c.execute(‘SELECT id FROM users’).fetchall()
通过以下语句在fetchall()后直接返回数据而非返回元组!
conn.row_factory = lambda cursor, row: row[0]
”也可以对游标设置
c = conn.cursor()
c.row_factory = lambda cursor, row: {‘foo’: row[0]}
取消方法
c.row_factory = None
c.execute(‘SELECT id FROM users’).fetchall()