sql - 外键列允许插入不在引用列中的值

Question

我必须表:

CREATE TABLE `artist` (
    `name`  TEXT NOT NULL,
    `gender`    TEXT NOT NULL,
    `city`  TEXT NOT NULL,
    PRIMARY KEY(name)
);

和

create table artwork(
    title text,
    location text,
    artist text,
    primary key (title, artist),
    foreign key (artist) references artist(name)
    );

“artwork”表中的“artist”列允许我插入不在引用列中的数据。

The FOREIGN KEY constraint also prevents invalid data from being inserted into the foreign key column, because it has to be one of the values contained in the table it points to. (c) W3school

我是不是用错方法了？

Answer 1

你使用 SQLite 吗？
如果是这样，您需要先运行

PRAGMA foreign_keys = ON;

虽然 SQLite 确实提供外键约束，但默认情况下它是禁用的。