Python 到 SQLite3

Question

我正在制作一个项目，我在其中使用 Python 连接到数据库，然后更新和更改内容。我在尝试检索信息时遇到了问题。

我正在使用这段代码:

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()

从这里我得到了错误:

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

我该如何解决这个错误？

Answer 1

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

你缺少空间，你应该这样更新

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