未捕获错误:UNIQUE约束失败:award.award_id

Question

我正试图创建一个名为award的表，并插入我写的值，但我在试图解决这个问题时运气不佳。

CREATE TABLE award
(
award_id varchar(50) NOT NULL,
year int NOT NULL,
category varchar(50) NOT NULL,
movie_id CHAR(3) NOT NULL,
star_id CHAR(3) NOT NULL,
PRIMARY KEY (award)
FOREIGN KEY (movie_id) REFERENCES movie (movie_id),
FOREIGN KEY (star_id) REFERENCES star (star_id)
);
INSERT INTO award (award_id, year, category, movie_id, star_id) 
VALUES ('oscars', 2016, 'best_picture', 108, 210),
('oscars', 2019, 'best_director', 109, 211),
('oscars', 2010, 'best_actress', 110, 212),
('oscars', 2021, 'best_actor', 111, 213),
('cannes', 2011, 'best_actress', 112, 214),
('cannes', 2000, 'best_actor', 113, 215);

我正在尝试用我添加的插入内容创建一个奖励表。

Answer 1

award_id(primary_key(必须是唯一的。