how to read data.sqlite file in Python?

Question

I have one data.sqllite file!

can anyone tell me what is the way to read that file in Python??

Thanks in Advance!!

Crapy · Accepted Answer · 2020-07-21 19:27:22Z

1

import sqlite3
conn = sqlite3.connect('example.db')

answered Jul 21, 2020 at 19:27

Crapy

3421 silver badge8 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

i want to see whole the data in python , how to do that, once i read it because after that i want to run query!

for row in conn.execute('SELECT * FROM table'): print row