mysql - SQL 和外键，引用

Question

你好，我在创建表时遇到了问题。我想创建引用“模型”的表

CREATE TABLE Marka(
id_marki INT PRIMARY KEY NOT NULL ,
nazwa VARCHAR(40) NOT NULL ,
id_modelu int
FOREIGN KEY(id_modelu) REFERENCES Model(id_modelu) ON DELETE CASCADE
) ENGINE=INNODB;

模型是带有 ID 和名称的简单表格。当我点击运行它时，出现了这个错误:

#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 'FOREIGN KEY(id_modelu) REFERENCES Model(id_modelu) ON DELETE CASCADE ) ENGINE=I' at line 5

我做错了什么？

Answer 1

你在 id_modelu int 之后少了一个逗号

CREATE TABLE Marka
(
  id_marki INT PRIMARY KEY NOT NULL,
  nazwa VARCHAR(40) NOT NULL,
  id_modelu int,
  FOREIGN KEY(id_modelu) REFERENCES Model(id_modelu) ON DELETE CASCADE
) ENGINE=INNODB;