I am trying to read a sqlite file in Jupyter Notebook, however this error appears: OperationalError: no such table: Can someone help me?
import sqlite3
conn = sqlite3.connect('escola.sqlite')
c = conn.cursor()
def leitura_todos_dados():
c.execute("SELECT * FROM escola")
for linha in c.fetchall():
print(linha)
leitura_todos_dados()
OperationalError Traceback (most recent call last) in () ---- > 1 reading_all_dates () 2in reading_all_data () 10 11 def read_to_data (): --- > 12 c.execute ("SELECT * FROM school") 13 for line in c.fetchall (): 14 print (line)
OperationalError: no such table: school