MySQL Workbench-错误1215:无法添加外键约束

Question

现在，在您将其标记为重复之前，我浏览了许多堆栈溢出解决方案。

名称匹配

数据类型匹配

两者都不是零，

有什么问题？

这是我的代码：

create database Registration;
use Registration;
create table Department(DepartmentID varchar(25) NOT NULL, DepartmentName varchar(25),
PRIMARY KEY(DepartmentID));
insert into Department(DepartmentID, DepartmentName) values ('DE1', 'Engligh');
insert into Department(DepartmentID, DepartmentName) values ('DS2', 'Science');
insert into Department(DepartmentID, DepartmentName) values ('DM3', 'Math');
create table Course(CourseID varchar(25), CourseName varchar(25), DepartmentID varchar(25) NOT NULL,
PRIMARY KEY (CourseID),
FOREIGN KEY(DepartmentID) REFERENCES Departmnet(DepartmentID));

Answer 1

create table Course(CourseID varchar(25), CourseName varchar(25),  DepartmentID varchar(25) NOT NULL,
PRIMARY KEY (CourseID),
FOREIGN KEY(DepartmentID) REFERENCES Department(DepartmentID));

您在参考文献中的表名部门上犯了拼写错误