Notice
Recent Posts
Recent Comments
Link
«   2026/04   »
일 월 화 수 목 금 토
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30
Tags
more
Archives
Today
Total
관리 메뉴

Chimy's Program

ERROR 1822 (HY000): Failed to add the foreign key constraint. Missing index for constraint '~' in the referenced table '~' 본문

error

ERROR 1822 (HY000): Failed to add the foreign key constraint. Missing index for constraint '~' in the referenced table '~'

chimy 2020. 12. 31. 20:33

Missing index for constraint '~' in the referenced table '~'

 

foreign key를 설정하려고 할 때 참조되는 테이블의 컬럼이 기본키(Primary Key)이거나 유니크 키(Unique Key)여야 하는데 설정이 안되었기 때문에 오류가 발생했다

 

 

 

해결1.

해당 컬럼을 유니크 키로 변경한다

 

 

정상적으로 외래키가 반영된다

저작자표시 비영리 변경금지 (새창열림)

'error' 카테고리의 다른 글

Warning: Each child in a list should have a unique "key" prop.  (0) 2021.01.16
Port ~ required by Tomcat v~ Server at localhost is already in use. The server may already be running in another process, or a system process may be using the port. To start this server you will need to stop the other process or change the port number(s).  (0) 2020.10.17
The server cannot be started because one or more of the ports are invalid. Open the server editor and correct the invalid ports.  (0) 2020.10.16
error: failed to push some refs to '~'  (0) 2020.08.28
error: could not read '.git/rebase-apply/head-name': No such file or directory  (0) 2020.04.26
'error' Related Articles more
Comments