检测到 MySQL 语法错误，但不知道是什么问题？

Question

我输入了以下代码而且我不知道我的代码有什么问题。

CREATE TABLE SlotGame
(
  gID CHAR(12),
  jackpot DECIMAL(10,2) NOT NULL,
  sID CHAR(5) NOT NULL,
  PRIMARY KEY(gID),
  FOREIGN KEY(gID) REFERENCES Game(gID),
  FOREIGN KEY(sID) REFERENCES Slot(sID),
);

向我展示了以下内容:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 9

希望有人能告诉我哪里出了问题。非常感谢。

Answer 1

您只需要删除最后一个逗号:

CREATE TABLE SlotGame
(
  gID CHAR(12),
  jackpot DECIMAL(10,2) NOT NULL,
  sID CHAR(5) NOT NULL,
  PRIMARY KEY(gID),
  FOREIGN KEY(gID) REFERENCES Game(gID),
  FOREIGN KEY(sID) REFERENCES Slot(sID) <-- comma removed
);