问题描述
我已经有这个问题几个小时了.在 SQL Server 中，我运行了这个查询:
I have been having this problem for a couple of hours now. In SQL Server, I ran this query :
INSERT INTO USERS_AVATAR(userId, avatId) VALUES ('1', '213');
INSERT INTO USERS_AVATAR(userId, avatId) VALUES ('2', '312');
但消息显示:
消息 547，第 16 级，状态 0，第 1 行
INSERT 语句与 FOREIGN KEY 约束FKUSERS_AVAT731248"冲突.冲突发生在数据库gk314"、表gk314.USERS"、列userId"中.
Msg 547, Level 16, State 0, Line 1
The INSERT statement conflicted with the FOREIGN KEY constraint "FKUSERS_AVAT731248". The conflict occurred in database "gk314", table "gk314.USERS", column 'userId'.
消息 547，第 16 级，状态 0，第 2 行
INSERT 语句与 FOREIGN KEY 约束FKUSERS_AVAT731248"冲突.冲突发生在数据库gk314"、表gk314.USERS"、列userId"中.
Msg 547, Level 16, State 0, Line 2
The INSERT statement conflicted with the FOREIGN KEY constraint "FKUSERS_AVAT731248". The conflict occurred in database "gk314", table "gk314.USERS", column 'userId'.
请帮忙！
推荐答案
在将 userIds 1 和 2 插入 USERS_AVATAR 之前，必须先将它们插入到表 USERS 中.这就是 FOREIGN KEY 约束所要求的.
Before inserting userIds 1 and 2 into USERS_AVATAR, you must first insert them into table USERS. That is what the FOREIGN KEY constraint is requiring.
这篇关于INSERT 语句与 FOREIGN KEY 约束冲突.数据库发生冲突的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！