mysql 外键引用语法错误

Question

CREATE TABLE comments (
  id INT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
  body TEXT DEFAULT NULL,
  user_id INT(7) UNSIGNED NOT NULL,
  PRIMARY KEY (id)
  FOREIGN KEY (user_id) REFERENCES user(id)
) AUTO_INCREMENT = 1;

我似乎无法使用 FOREIGN 键来处理此语句。我不断收到错误

ERROR 1064 (42000): You have an error in your SQL syntax; ch eck the manual that corresponds to your MySQL server version for the right syntax to use near 'FOREIGN KEY (user_id) REF ERENCES user(id) ) AUTO_INCREMENT = 1' at line 6

Answer 1

主键后添加逗号:

CREATE TABLE comments (
  id INT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
  body TEXT DEFAULT NULL,
  user_id INT(7) UNSIGNED NOT NULL,
  PRIMARY KEY (id),
  FOREIGN KEY (user_id) REFERENCES user(id)
) AUTO_INCREMENT = 1;