Mysql错误1452-无法添加或更新子行:外键约束失败
我有一个奇怪的问题。 我试图添加一个外键引用另一个表,但由于某种原因失败。 由于我对MySQL的知识有限,唯一可能会怀疑的是在引用我想引用的表上的另一个表上有一个外键。
这里是我的表关系的图片,通过phpMyAdmin: 关系生成
我已经在两个表上做了一个SHOW CREATE TABLE查询, sourcecodes_tags是带有外键的表, sourcecodes是被引用的表。
CREATE TABLE `sourcecodes` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(11) unsigned NOT NULL, `language_id` int(11) unsigned NOT NULL, `category_id` int(11) unsigned NOT NULL, `title` varchar(40) CHARACTER SET utf8 NOT NULL, `description` text CHARACTER SET utf8 NOT NULL, `views` int(11) unsigned NOT NULL, `downloads` int(11) unsigned NOT NULL, `time_posted` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `user_id` (`user_id`), KEY `language_id` (`language_id`), KEY `category_id` (`category_id`), CONSTRAINT `sourcecodes_ibfk_3` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `sourcecodes_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `sourcecodes_ibfk_2` FOREIGN KEY (&#
如果觉得《错误代码1452_Mysql错误1452-无法添加或更新子行:外键约束失败》对你有帮助,请点赞、收藏,并留下你的观点哦!