INSERT 语句与 FOREIGN KEY 约束冲突.数据库发生冲突

2022-01-20 00:00:00 sql foreign-keys sql-server

我已经有这个问题几个小时了.在 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.

相关文章