如何修复：“在sql“SELECT*FROM Country”上执行失败：没有这样的表：Country”

Question

我写了这段代码并尝试了所有可能的解决方案。仍然坚持这一点。你知道吗

pat = 'C:\\Users\\gpsin\\Desktop\\football project\\'

database = pat + 'database1.sqlite'

con = sqlite3.connect(database)

print("Connection Successful",con)

countries = pd.read_sql_query('SELECT * FROM Country', con)

matches = pd.read_sql_query("SELECT * from Match", con)

leagues = pd.read_sql_query("SELECT * from League", con)

teams = pd.read_sql_query("SELECT * from Team", con)

tempmatch = pd.read_sql_query("SELECT * from Match", con)

matches3 = matches2 = matches

显示错误：

Execution failed on sql 'SELECT * FROM Country': no such table: Country

尽管数据库已创建 连接成功

Answer 1

您的数据库中似乎没有表Country。你需要检查一下。你知道吗

否则，你的道路可能会有错误。请看以下帖子：DatabaseError: Execution failed on sql : no such table: League