ALTER TABLE student ADD CONSISTENT FK_gradeID FOREIGN KEY (gradeID) REFERENCES grade(gradeID);
ALTER TABLE student ADD CONSISTENT FK_studentNo FOREIGN KEY (studentNo) REFERENCES result(studentNo);
ALTER TABLE result ADD CONSISTENT FK_subjectNo FOREIGN KEY (subjectNo) REFERENCES SUBJECT(subjectNo);
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FK_gradeID foreign key (gradeID) references grade(gradeID)' at line 1
uj5u.com熱心網友回復：
alter table student add constraint FK_gradeID foreign key student(gradeID) references grade(gradeID);
。。。
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/26636.html
標籤：MySQL