我真的不太懂编程,所以如果我的问题看起来很老套,我很抱歉。每当我尝试这个程序时,我都会收到"错误代码:1215:无法添加外键约束MYSql"
create table department(dept_name varchar(20) primary key,
building varchar(15),
budget numeric(12,2));
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);
有人能帮我解决吗
您尚未定义要引用dept_name
的哪一列。请尝试这个:
create table department(dept_name varchar(20) primary key,
building varchar(15),
budget numeric(12,2));
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(dept_name));