SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS `teacher`;
DROP TABLE IF EXISTS `Laboratory`;
DROP TABLE IF EXISTS `course`;
DROP TABLE IF EXISTS `class`;
DROP TABLE IF EXISTS `lab`;
DROP TABLE IF EXISTS `major_course`;
DROP TABLE IF EXISTS `curriculum`;
DROP TABLE IF EXISTS `Lab_Course`;
create table teacher(
t_id int primary key,
t_name varchar(20) not null,
title varchar(20) not null,
post varchar(20) not null
)ENGINE=InnoDB DEFAULT CHARSET=utf8;create table Laboratory(
Laboratory_name varchar(20) primary key,
Location varchar(20) not null,
number int
)ENGINE=InnoDB DEFAULT CHARSET=utf8;create table course(
course_name varchar(20) primary key,
m_name varchar(20)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;create table class(
c_name varchar(20) primary key,
c_number int not null,
grade int not null,
major varchar(20) not null
)ENGINE=InnoDB DEFAULT CHARSET=utf8;create table major_course(
m_id int primary key,
m_name varchar(20) not null,
grade int not null,
c_class varchar(20) not null
)ENGINE=InnoDB DEFAULT CHARSET=utf8;create table curriculum(
l_course varchar(20) primary key,
hours int not null,
course_num int null
)ENGINE=InnoDB DEFAULT CHARSET=utf8;create table Lab_Course(
Laboratory_id varchar(20) primary key,
l_course varchar(20),
foreign key(l_course) references curriculum (l_course)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;create table lab(
l_course varchar(20),
foreign key(l_course) references curriculum (l_course),
course_name varchar(20),
foreign key (course_name) references course(course_name),
class_hour int not null,
primary key (l_course,course_name)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;
alter table Laboratory add foreign key(l_course) REFERENCES curriculum(l_course);
alter table curriculum add foreign key(Laboratory_id) REFERENCES Laboratory (Laboratory_id);
alter table teacher add foreign key(t_name) REFERENCES Laboratory (t_name);
[err] 1072 - key column 'l_course' doesn't exist in table

看上去是没有 I_course 这个内容，是不是目标内容有差异