Skip to content Skip to sidebar Skip to footer

Cannot Add Foreign Key Constraignt Mysql

I am creating a database in MySQL for school. It has come up with the error 'cannot add foreign key constraint.' I have looked at other similar questions but cannot find out how it

Solution 1:

Update your entries table like so:

CREATE TABLE IF NOT EXISTS entries(
entry_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
exam_date DATE NOT NULL,
student_id INT REFERENCES students(student_id),
subject_id INT REFERENCES subjects(subject_id),
PRIMARY KEY(entry_id)
)

Post a Comment for "Cannot Add Foreign Key Constraignt Mysql"