主页 / 问题 / 674594
Accepted
Samvel
Asked:2020-06-03 05:32:46 +0000 UTC2020-06-03 05:32:46 +0000 UTC

MySQL。外键。创建表时出错

  • 772

为什么命令不起作用？

CREATE table Marriage (
        serial_num_husband varchar(30) NOT NULL FOREIGN KEY REFERENCES People(serial_number_passport),
        serial_num_wife varchar(30) NOT NULL FOREIGN KEY REFERENCES People(serial_number_passport));

给出错误信息

需要逗号或右括号。（在位置 71 的“FOREIGN KEY”附近）表达式的意外开始。（在位置 101 的“serial_number_passport”附近）表达式的意外开始。（在位置 133 的“serial_num_wife”附近）

PS 有一张表People有PRIMARY KEY serial_number_passport

mysql

1 个回答

  1. Best Answer

    试试这样：

    CREATE table Marriage (   
    serial_num_husband varchar(30) NOT NULL,
    serial_num_wife varchar(30) NOT NULL,
    FOREIGN KEY (serial_num_husband) REFERENCES People(serial_number_passport),
    FOREIGN KEY (serial_num_wife) REFERENCES People(serial_number_passport)
)
    • 1

相关问题