CREATE TABLE SELECTION
(SID CHAR(4),
SUB_ID CHAR(4),
PRIOR CAHR(2),
PRIMARY KEY (SID,SUB_ID),
FOREIGN KEY (SID) REFERENCES STUDENT (SID),
FOREIGN KEY (SUB_ID) REFERENCES SUBJECT (SUB_ID));


點解上面既語言用 MYSQL 5.1 執行唔到? 正確應該點寫?
做梗project,希望識既人可以幫下我,萬分感謝!!!

[ 本帖最後由 Master 於 2011-1-31 11:31 編輯 ]

要先建立表格STUDENT及SUBJECT,否則無法REFERENCES