SQL 工作台：外键命令错误中的引用 "REFERENCES" 在此位置无效，期望( '('

Question

My REFERENCES在MySQL Workbench中不断收到此错误。这是代码

使用my_database；

Create table bands (
id int NOT NULL AUTO_INCREMENT,
name VARCHAR(255) NOT NULL,
primary key (id)
);

Create Table albums(
id int Not NUll auto_increment,
name Varchar(255) NOT NULL,
release_year INT,
band_id INT NOT NULL,
primary key (id),
foreign key band_id references bands(id)
);

Answer 1

您忘记将(和)放在外键之间

CREATE TABLE albums(
id int Not NUll AUTO_INCREMENT,
name Varchar(255) NOT NULL,
release_year INT,
band_id INT NOT NULL,
PRIMARY KEY (id),
FOREIGN KEY (band_id) REFERENCES bands(id)
);