python-3.x - 当错误涉及 "sqlite3.OperationalError: incomplete input "') 时如何修复 ''

Question

这是我收到的错误:

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

Answer 1

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

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