我正在制作一个项目,我在其中使用 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
我该如何解决这个错误?
请您参考如下方法:
cursor = conn.execute("SELECT ID,ResidentTitle,ResidentForname FROMResidents")
-------------------------------------------------------------------^
你缺少空间,你应该这样更新
cursor = conn.execute("SELECT ID,ResidentTitle,ResidentForname FROM Residents")
