<div>CREATE TABLE users(</div> <div>userNo CHAR(5)<span style="white-space:pre;"> </span>NOT NULL,</div> <div>userName CHAR(20),</div> <div>regDay DATE,</div> <div>phone CHAR(15),</div> <div>year DATE,</div> <div>PRIMARY KEY (userNo));</div> <div><br></div> <div> <div>CREATE TABLE food(</div> <div>foodNo CHAR(5)<span style="white-space:pre;"> </span>NOT NULL,</div> <div>foodName CHAR(20),</div> <div>foodPrice INT,</div> <div>stock INT,</div> <div>PRIMARY KEY (foodno));</div></div> <div><br></div> <div>이렇게 기본 테이블을 2개 만들고</div> <div><br></div> <div> <div>CREATE TABLE foodorder(</div> <div>orderNo CHAR(5)<span style="white-space:pre;"> </span>NOT NULL,</div> <div>userNo CHAR(5),</div> <div>foodNo CHAR(5),</div> <div>foodPrice INT,</div> <div>orderDay DATE,</div> <div>PRIMARY KEY (orderNo),</div> <div>FOREIGN KEY (foodNo) REFERENCES food(foodNo),</div> <div>FOREIGN KEY (userNo) REFERENCES users(userNo),</div> <div>FOREIGN KEY (foodPrice) REFERENCES food(foodPrice));</div></div> <div><br></div> <div>이 테이블을 만들려고 하는데</div> <div>ERROR 1215 (HY000): Cannot add foreign key constraint가 뜨면서 테이블을 만들지 못합니다...</div> <div>외래키 설정은 제대로 한 거 같은데 다른 문제가 있을까요?</div>
<a href="http://steamsignature.com"><img src="http://steamsignature.com/card/1/76561198100689035.png" alt="" title=""></a>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.