错误代码:1215.--无法添加外键约束

Question

create database university;
use university;
create table department
(dept_name varchar(20),
building  varchar(15),
budget    numeric(12,2),
primary key(dept_name));
create table course 
(course_id   varchar(7),
title       varchar(50),
dept_name   varchar(20),
credits     numeric(2,0),
primary key(course_id),
foreign key(dept_name) references department);

Answer 1

您错过了指定department表的目标列

foreign key(dept_name) references department(dept_name));