Python to SQLite3

Question

I am making a project where I connect to a database with Python then update and change things. I have run into problems when trying to retrieve information.

I am using this code:

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

print ("Opened database sucessfully")

cursor = conn.execute("SELECT ID,ResidentTitle,ResidentForname FROM Residents")
for row in cursor:
    print ("ID = "), row[0]
    print ("ResidentTitle ="), row[1]
    print ("Name ="), row[2]

print ("done");
conn.close()

from this I am getting back the error:

Traceback (most recent call last):
File "C:/sqlite/Sqlplz.py", line 7, in <module>
cursor = conn.execute("SELECT ID,ResidentTitle,ResidentForname FROM Residents")
sqlite3.OperationalError: no such table: Residents

How can I resolve this error?

You are missing space. FROMResidents must be FROM Residents — Adem Öztaş
– Adem Öztaş, Commented Nov 25, 2015 at 16:27
@Alexander: the SQL in your code doesn't match the SQL in the error message; double-check that they're both up-to-date? — nickgrim
– nickgrim, Commented Nov 25, 2015 at 16:37
Wait, where is the confusion? Error message says everything. There is no table Residents in the database. — David Ferenczy Rogožan
– David Ferenczy Rogožan, Commented Nov 25, 2015 at 16:39
Is the file Project.db in the current directory? If not, then the connect statement creates a new empty database. — Hai Vu
– Hai Vu, Commented Nov 25, 2015 at 17:49

Adem Öztaş · Accepted Answer · 2015-11-25 16:29:36Z

1

cursor = conn.execute("SELECT ID,ResidentTitle,ResidentForname FROMResidents")
-------------------------------------------------------------------^

You are missing space, you should update like that

cursor = conn.execute("SELECT ID,ResidentTitle,ResidentForname FROM Residents")

answered Nov 25, 2015 at 16:29

Adem Öztaş

21.6k5 gold badges36 silver badges42 bronze badges

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

2 Comments

Alexander Over a year ago

i uploaded the wrong code, i updated the problem, sorry.

Adem Öztaş Over a year ago

@Alexander, did you create Residents table?

Alexander · Accepted Answer · 2015-11-25 16:43:24Z

0

Problem is fixed, issue with a broken save file.

answered Nov 25, 2015 at 16:43

Alexander

212 bronze badges

Collectives™ on Stack Overflow

Python to SQLite3

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related