老师，我添加或修改的时候遇到外键问题，网上我找过试了都没成功

Question

### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`o2o`.`tb_product_category`, CONSTRAINT `fk_procate_shop` FOREIGN KEY (`shop_id`) REFERENCES `tb_shop` (`shop_id`))
; SQL []; Cannot add or update a child row: a foreign key constraint fails (`o2o`.`tb_product_category`, CONSTRAINT `fk_procate_shop` FOREIGN KEY (`shop_id`) REFERENCES `tb_shop` (`shop_id`)); nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`o2o`.`tb_product_category`, CONSTRAINT `fk_procate_shop` FOREIGN KEY (`shop_id`) REFERENCES `tb_shop` (`shop_id`))

Answer 1

翔仔 2018-02-23 23:04:46

同学好，此类错误比较明显呢，违反了shopid的外键约束，即添加商品类别信息的时候，添加的shop_id在tb_shop这张表里不存在。以后类似的问题希望同学能尝试去解决哦，码农必备的基本功咱必须得攻克：）

• 提问者 慕斯卡6955199 #1

  shop_id是在tb_shop里呢主键，有呢

• 翔仔 #2

  请问问题解决了没，翔仔意思是同学比如插入了shopid为1的商品类别 但是shopid为1的记录在tb_shop里没有。。

• wexin_Mr_NoBody 回复 翔仔 #3

  翔哥每天得回复多少问题啊.....好多问题确实挺简单的。静下心来看一看，找一找。比如单词错误，少了个空格引号啥的....

点开查看后面1条评论