Query sqlite table using python

import sqlite3 as db
 
conn = db.connect('mytest.db')
conn.row_factory = db.Row
cursor = conn.cursor()
 
cursor.execute("select * from person")
rows = cursor.fetchall()
for row in rows:
   print("%s %s %s" % (row["name"], row["age"], row["address"]))
conn.close()

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.