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

The INSERT statement conflicted with the FOREIGN KEY constraint. The conflict occurred in database(INSERT 语句与 FOREIGN KEY 约束冲突.数据库发生冲突)

本文介绍了INSERT 语句与 FOREIGN KEY 约束冲突.数据库发生冲突的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我已经有这个问题几个小时了.在 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 12 插入 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 约束冲突.数据库发生冲突的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本文标题为:INSERT 语句与 FOREIGN KEY 约束冲突.数据库发生冲突

基础教程推荐