Error during saving query data into dataframe

Question

I am trying to access sqlite db - test.db and running simple query "SELECT * FROM TABLE" and trying to save it in dataframe. It seems the code is fine as I searched and found similar codes that seem to work for others. NOTE: I am running the code in Jupyter iNotebook.

import sqlite3
import pandas as pd
con = sqlite3.connect('test.db')
myFrames = pd.read_sql_query("SELECT * FROM TABLE", con)

I get error

Error OperationalError: near "TABLE": syntax error

(lots of lines in between)

DatabaseError: Execution failed on sql 'SELECT * FROM TABLE': near "TABLE": syntax error

Also, This piece prints out rows very well. So connection is working

conn = sqlite3.connect("test.db")
cur = conn.cursor()
for row in cur.execute("SELECT * FROM test_rank"):
    print(row)

Table is reserved word in SQL. You need to give the real name of the table or rename otherwise. — skrubber
– skrubber, Commented Oct 25, 2017 at 21:09

skrubber · Accepted Answer · 2017-10-25 21:21:04Z

1

Table is a reserved keyword. Replace it with the real name of the table.

answered Oct 25, 2017 at 21:21

skrubber

1,1051 gold badge9 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

Error during saving query data into dataframe

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related