我写了这段代码并尝试了所有可能的解决方案。仍然坚持这一点。你知道吗
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
尽管数据库已创建 连接成功
您的数据库中似乎没有表Country。你需要检查一下。你知道吗
否则,你的道路可能会有错误。请看以下帖子:DatabaseError: Execution failed on sql : no such table: League
相关问题 更多 >
编程相关推荐