Error code 1215 Cannot add foreign key constraint in MySQL Workbench

CREATE TABLE QUALIFIED (FacultyID INT NOT NULL, CourseID CHAR(8) NOT NULL, DateQualified DATE, CONSTRAINT Qualified_PK PRIMARY KEY (FacultyID, CourseID), CONSTRAINT Qualified_FK1 FOREIGN KEY (FacultyID) REFERENCES Faculty (FacultyID), CONSTRAINT Qualified_FK2 FOREIGN KEY (CourseID) REFERENCES Course (CourseID));

Resolve it.

Answer rating: 100% (QA)

The error code 1215 in MySQL Workbench typically indicates an issue with creating a foreign key cons... View the full answer