Share Yours
::: Language :::
한국어
English
中国
日本語
Toggle navigation
Dev Jinwon's Share
Home
Profile
Language
Java
Javacript | Ajax
HTML | CSS
Magento
PHP
Python
System
Server
Database
APM
Cloud Service 관련
Kubernetes
Framework
Spring
Codeigniter
Jersey
Script Framework
jQuery
AngularJS
Etc,.
Algorithm : 알고리즘
해결된 이슈
Questions
Design Pattern : 디자인 패턴
Data Structure : 자료구조
Codility
Open API
IT 용어
해외근무 해외생활
bookmark
Sign Up
Sign In
java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails
Article
Home
Board
해결된 이슈
Article
java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails
Posted on Jan 07.2019 by
Dev Jinwon
java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails
Error Log Msg :
java.sql.SQLIn
�
tegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails
(`schema name`.`table name`, CONSTRAINT `FK_aaaaaaaaaaaaaaaaa` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`))
Caution :
자식 테이블에 입력하려는 ID가 부모 테이블에 없는 경우가 존재하였음.
�
Reference :
https://stackoverflow.com/questions/5005388/cannot-add-or-update-a-child-row-a-foreign-key-constraint-fails
https://stackoverrun.com/ko/q/3240756
Posted in
해결된 이슈
Dev Jinwon's Share
f
t
Related Streams
×
Related Streams
in Youtube
Here is Dev Jinwon's Share
Joined Date : 2017-09-29
Language
Python
6
PHP
16
Magento
4
HTML | CSS
13
Javacript | Ajax
40
Java
48
System
Kubernetes
2
Cloud Service 관련
1
APM
8
Database
8
Server
17
Framework
Jersey
1
Codeigniter
15
Spring
21
Script Framework
AngularJS
1
jQuery
20
Etc,.
해외근무 해외생활
7
IT 용어
6
Open API
1
Codility
3
Data Structure : 자료구조
5
Design Pattern : 디자인 패턴
3
Questions
17
해결된 이슈
25
Algorithm : 알고리즘
9