这是我的代码:
conn=sqlite3.connect('myfile.db')
print(conn.execute("PRAGMA table_info(mytable);"))
当我运行时,会得到以下输出:
sqlite3.Cursor object at 0x02889FAO
如何打印出实际的sqlite3输出呢?import sqlite3
conn = sqlite3.connect('myfile.db')
cursor = conn.execute("PRAGMA table_info(mytable);")
results = cursor.fetchall()
print(results)
import sqlite3
from pprint import pprint
conn = sqlite3.connect('myfile.db')
cursor = conn.execute("PRAGMA table_info(mytable);")
results = cursor.fetchall()
pprint(results)
sqlite3.Row
对象,而不是一个list
。为了方便查看和打印这个输出,您需要将结果转换为字典。import sqlite3 as sl
con = sl.connect('db.sqlite')
con.row_factory = sl.Row
rows = con.execute('SELECT * FROM table').fetchall()
for row in rows:
print(dict(row))
print(row['column_name'])