首页 a foreign key constraint fails (`homework`.`check_in`, CONSTRAINT `check_in_ibfk_2` FOREIGN KEY (`id_card`) REFERENCES `guest` (`id_card`))

a foreign key constraint fails (`homework`.`check_in`, CONSTRAINT `check_in_ibfk_2` FOREIGN KEY (`id_card`) REFERENCES `guest` (`id_card`))

时间: 2023-11-20 15:57:42 浏览: 67

Navicat删除行时报Cannot delete or update a parent row: a foreign key constraint fails

5星 · 资源好评率100%

在SSM项目中执行一个删除用户操作时报错，遂在navicat中尝试是否可以直接删除，报如下所示错误 student表的主键是selectedcourse表的外键，当需要删除student表内的一行数据时，必须在selectedcourse表内设置该外键在删除时的属性方能实现删除。当我想删除student表内的某行数据时，也需要删除selectedcourse表内该student的选课信息。因此设置删除时CASCAED，当取值为Cascade时，则当在父表（即外键的来源表）中删除对应记录时，首先检查该记录是否有对应外键，如果有则也删除外键在子表（即包含外键的表）中的记录。从而实现删除s

这个错误是由于在`check_in`表中的`id_card`列上定义了一个外键约束，该约束引用了`guest`表中的`id_card`列，但是在插入或更新`check_in`表时，提供的`id_card`值在`guest`表中不存在，因此触发了外键约束失败。要解决此问题，您需要确保在插入或更新`check_in`表时，提供的`id_card`值在`guest`表中存在。如果您确定该值存在，则可能是由于数据类型不匹配或其他约束条件导致的问题。您可以检查表定义和数据类型以查找问题所在。

阅读全文

最新推荐

rime输入法-下载 RIME／中州韻輸入法引擎，是一個跨平臺的輸入法算法框架基於這一框架，Rime 開發者與其他開源社區的參與者在 Windows、macOS、Linux、Android 等平

rime输入法-下载 RIME／中州韻輸入法引擎，是一個跨平臺的輸入法算法框架。基於這一框架，Rime 開發者與其他開源社區的參與者在 Windows、macOS、Linux、Android 等平臺上創造了不同的輸入法前端實現。

a foreign key constraint fails (`homework`.`check_in`, CONSTRAINT `check_in_ibfk_2` FOREIGN KEY (`id_card`) REFERENCES `guest` (`id_card`))

相关推荐

system verilog constraint layering.rar_constraint_random_system

: a foreign key constraint fails (54_fanmao_students.Us, CONSTRAINT Us_ibfk_2 FOREIGN KEY (BloodTypeID) REFERENCES Bi (id))

Cannot add or update a child row: a foreign key constraint fails (fsxu_1_json.edges, CONSTRAINT edges_ibfk_2 FOREIGN KEY (to_id) REFERENCES nodes (id))

Cannot add or update a child row: a foreign key constraint fails (newco_db.BrewEvent, CONSTRAINT BrewEvent_ibfk_1 FOREIGN KEY (machineId) REFERENCES Machine (machineId))

mysql.connector.errors.IntegrityError: 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (fsxu_json.keywords, CONSTRAINT keywords_ibfk_1 FOREIGN KEY (node_id) REFERENCES nodes (id))

Cannot add or update a child row: a foreign key constraint fails (ry-cloud.sx_major_task, CONSTRAINT sx_major_task_ibfk_1 FOREIGN KEY (major_task_id) REFERENCES sx_floor_task (major_task_id) ON DELETE CASCADE ON UPDATE CASCADE

怎么解决Cannot add or update a child row: a foreign key constraint fails (shopping.sold_out_list, CONSTRAINT sold_out_list_ibfk_1 FOREIGN KEY (SOLD_ID) REFERENCES salesman (SID))

a foreign key constraint fails (hospital.schedule, CONSTRAINT schedule_ibfk_1 FOREIGN KEY (Room_no) REFERENCES room (Room_no))

Cannot add or update a child row: a foreign key constraint fails (company.project, CONSTRAINT project_ibfk_1 FOREIGN KEY (manager_id) REFERENCES employee (employee_id))

Cannot change column 'id': used in a foreign key constraint 'class_ibfk_1' of table 'exp.class'

Cannot add or update a child row: a foreign key constraint fails (hotel.inhotel, CONSTRAINT inhotel_ibfk_1 FOREIGN KEY (cusname) REFERENCES customer (cusname))

Cannot add or update a child row: a foreign key constraint fails (myshop.cart, CONSTRAINT cart_ibfk_1 FOREIGN KEY (userid) REFERENCES user (id))

3730 - Cannot drop table 'student' referenced by a foreign key constraint 'sc_ibfk_1' on table 'sc'.

IntegrityError at /like-post (1452, 'Cannot add or update a child row: a foreign key constraint fails (b.likepost, CONSTRAINT likepost_ibfk_1 FOREIGN KEY (post_id) REFERENCES post (id))')

foreign key constraint fails (wer q.employment, CONSTRAINT employment_ibfk_1 FOREIGN KEY (Esno) REFERENCES student (Sno))

最新推荐

rime输入法-下载 RIME／中州韻輸入法引擎，是一個跨平臺的輸入法算法框架 基於這一框架，Rime 開發者與其他開源社區的參與者在 Windows、macOS、Linux、Android 等平

C语言数组操作：高度检查器编程实践

管理建模和仿真的文件

【KUKA系统变量进阶】：揭秘从理论到实践的5大关键技巧

如何使用Python编程语言创建一个具有动态爱心图案作为背景并添加文字'天天开心（高级版）'的图形界面？

基于Swift开发的嘉定单车LBS iOS应用项目解析

"互动学习：行动中的多样性与论文攻读经历"

PROTEUS符号定制指南：个性化元件创建与修改的全面攻略

https://www.lagou.com/wn/爬取该网页职位名称，薪资待遇，学历，企业类型，工作地点数据保存为CSV文件的python代码

钗头凤声乐表演的二度创作分析报告

rime输入法-下载 RIME／中州韻輸入法引擎，是一個跨平臺的輸入法算法框架基於這一框架，Rime 開發者與其他開源社區的參與者在 Windows、macOS、Linux、Android 等平