如何修复"sqlite3.OperationalError:输入不完整当错误是关于 ''') [英] How to fix " sqlite3.OperationalError: incomplete input " when the error is regarding ''')

问题描述

这是我得到的错误:

回溯(最近一次调用最后一次):文件/Users/My文档/自主学习/BBA编码相关工作/创建一个带有 SQLite3 for Python/MarketCo1.py 的数据库"，第 89 行，在''');sqlite3.OperationalError:输入不完整

Traceback (most recent call last): File "/Users/My Documents/Independent Learning/BBA Coding Related Work/Creating a Database with SQLite3 for Python/MarketCo1.py", line 89, in '''); sqlite3.OperationalError: incomplete input

以下是我使用的代码:

cursor.execute('''CREATE TABLE ContactEmployee(
   ContactEmployeeID INTEGER PRIMARY KEY, 
   ContactID INTEGER, EmployeeID INTEGER, 
   ContactDate NUMERIC, 
   Description TEXT,  
   FOREIGN KEY(ContactID) REFERENCES Contact(ContactID), 
   FOREIGN KEY(EmployeeID) REFERENCES Employee(EmployeeID)
   ''')
db.commit()

推荐答案

你缺少一个右大括号，正如 glibdud 在评论中提到的:

You are missing a closing brace, as mentioned by glibdud in the comments:

cursor.execute('''CREATE TABLE ContactEmployee(
  ContactEmployeeID INTEGER PRIMARY KEY, 
  ContactID INTEGER, EmployeeID INTEGER, 
  ContactDate NUMERIC, 
  Description TEXT,  
  FOREIGN KEY(ContactID) REFERENCES Contact(ContactID), 
  FOREIGN KEY(EmployeeID) REFERENCES Employee(EmployeeID))
  ''')
db.commit()

这篇关于如何修复"sqlite3.OperationalError:输入不完整当错误是关于 ''')的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！