Sqlite3 in Python not fetching data

Question

I have a sqlite3 DB with a few rows in it. When I try to fetch data from it in Python, fetchall returns an empty list.

  con = sqlite3.connect("commands.db")
  cursor = con.cursor()
  con.execute("SELECT * FROM commands;")
  existing = cursor.fetchall()
  print(existing)
  # Prints []

The data is being inserted in a different part of the project fine. I verified this by opening the DB in "DB Browser for SQLite" and running the following command. This returned the data in the table with no problem.

SELECT * FROM commands;

Has anyone come across a similar issue? Thank you for the help in advance!

cursor.execute("SELECT * FROM commands;") with cursor not con. — C14L
– C14L, Commented Aug 20, 2021 at 8:55

Ertuğrul Çakıcı · Accepted Answer · 2021-08-20 08:56:24Z

2

Just change con.execute to cursor.execute. Then it should work

answered Aug 20, 2021 at 8:56

Ertuğrul Çakıcı

2264 silver badges9 bronze badges

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

1 Comment

Null Pointer Over a year ago

Thank you! I spent about an hour trying to figure it out. I think I need stronger coffee ☕

Collectives™ on Stack Overflow

Sqlite3 in Python not fetching data

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related