blocks|key|3580204|text|因为您试图在Student+Master的sub_id中插入一个在Subject表中不存在的值(+Subject表中没有引用)|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3580205|如果这些是第一条记录，那么请确保首先插入Subject，然后插入Student+Master|3580206|entityMap^0|6|E|X|7|1D|7|0|K|7|W|E|0^^$0|@$1|2|3|4|5|6|7|J|8|@$9|K|A|L|B|C]|$9|M|A|N|B|C]|$9|O|A|P|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|Q|8|@$9|R|A|S|B|C]|$9|T|A|U|B|C]]|D|@]|E|$]]|$1|H|3|-4|5|6|7|V|8|@]|D|@]|E|$]]]|I|$]]

Because you try to insert a value in <code>Student Master</code>'s sub_id which not exists int the <code>Subject</code> table (there is no reference in the <code>Subject</code> table) 

If those are the first records, then make sure, that you first insert the <code>Subject</code> then the <code>Student Master</code>

blocks|key|4438860|text|这是因为您在Student+Master表中插入sub_id不存在于表subject中的记录。请记住，您已经将sub_id+of+Student+Master表指定为subject表中的外键。这也意味着Student+Master表依赖于subject表。这破坏了引用的完整性。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4438861|entityMap^0|6|E|O|6|Z|7|1J|6|1T|E|2B|7|2T|E|3B|7|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]|$9|K|A|L|B|C]|$9|M|A|N|B|C]|$9|O|A|P|B|C]|$9|Q|A|R|B|C]|$9|S|A|T|B|C]|$9|U|A|V|B|C]|$9|W|A|X|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|G|$]]

It is because you are inserting record in the <code>Student Master</code> table which <code>sub_id</code> is not present on the table <code>subject</code>. Remember that you have specified <code>sub_id</code> of <code>Student Master</code> table as the foreign key from <code>subject</code> table. It also means the <code>Student Master</code> table is dependent on <code>subject</code> table. This breaks referential integrity.

blocks|key|4438910|text|+FK的工作方式是它不能在该列中有一个值，而该值也不在引用表的主键列中.
|type|blockquote|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|4438911|unstyled|4438912|因为它是一个外键约束，它告诉您要在表中插入的值，而该值不在所引用的表中。|4438913|因此，在插入Student表时，首先必须确保sub_id在subject表中可用。|CODE|4438914|编辑：|4438915|要纠正它，请在中尝试以下命令：|4438916|sp_help+'dbo.subject'|code-block|syntax|javascript|4438917|entityMap^0|0|10|0|0|0|6|7|M|6|T|7|0|0|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@$9|Y|A|Z|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|G|7|10|8|@]|D|@]|E|$]]|$1|H|3|I|5|G|7|11|8|@]|D|@]|E|$]]|$1|J|3|K|5|G|7|12|8|@$9|13|A|14|B|L]|$9|15|A|16|B|L]|$9|17|A|18|B|L]]|D|@]|E|$]]|$1|M|3|N|5|G|7|19|8|@]|D|@]|E|$]]|$1|O|3|P|5|G|7|1A|8|@]|D|@]|E|$]]|$1|Q|3|R|5|S|7|1B|8|@]|D|@]|E|$T|U]]|$1|V|3|-4|5|G|7|1C|8|@]|D|@]|E|$]]]|W|$]]

<blockquote>
 The way a FK works is it cannot have a value in that column that is not also in the primary key column of the referenced table.
</blockquote>

Because it is a foreign key constraint which tells you that the value you are trying to insert in the table which is not there in a referenced table.

So you first have to make sure while inserting into <code>Student</code> table that <code>sub_id</code> is available in the <code>subject</code> table.

EDIT:

To Rectify it try this command in Sql server management studio:

<pre><code>sp_help 'dbo.subject'
</code></pre>

blocks|key|3580256|text|您需要先插入主记录，然后插入子记录。首先在“学生母版”表中插入记录，然后尝试插入“主题”表。如果你把你的插入语句寄给我，会更好地帮助你。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3580257|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You need to insert the master record first and then the child record.
first insert the record in Student Master table and then try inserting in Subject table.
will be help you better if you send me your insert statement.

I have two tables having following fields:

Table 1 : 

Student Master

Fields : 

<pre><code>stu_id(primary key)
name
class
doc upload
sub_id(foreign_key)
</code></pre>

Table 2: 

Subject

Fields : 

<pre><code>sub_id(primary key)
subject name
</code></pre>

But when I insert the entries in the form it gives the following error.

<blockquote>
 The INSERT statement conflicted with the FOREIGN KEY constraint "FK__student_m__sub_i__0C85DE4D". The conflict occurred in database "test2", table "dbo.subject", column 'sub_id'**
</blockquote>

Kindly help where am I wrong??

foreign key conflict Unable to insert data

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有两个表，有以下字段：表1：学生硕士字段：stu_id(primary key)nameclassdoc uploadsub_id(foreign_key)表2：主题字段：sub_id(primary key)subject name但是，当我在表单中插入条目时，它会出现以下错误。INSERT语句与外键约束"FK__...

问无法插入数据的外键冲突
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问无法插入数据的外键冲突EN