MySQL导入。#1452 -无法添加或更新子行:外键约束失败

我曾尝试在PHP MyAdmin中将SQL文件导入到一个空数据库中,但出现了以下错误:

SQL query:

customer_eav_attribute` ADD CONSTRAINT `FK_CSTR_EAV_ATTR_ATTR_ID_EAV_ATTR_ATTR_ID` 
FOREIGN KEY (`attribute_id`)
REFERENCES `eav_attribute` (`attribute_id`) 
ON DELETE CASCADE ON UPDATE CASCADE

MySQL said: Documentation

#1452 - Cannot add or update a child row: 
a foreign key constraint fails (`example_db_name`.
`#sql-1ab1_b9d4`, CONSTRAINT `FK_CSTR_EAV_ATTR_ATTR_ID_EAV_ATTR_ATTR_ID` 
FOREIGN KEY (`attribute_id`) REFERENCES 
`eav_attribute` (`attribute_id`) ON DELETE 
CASCADE ON UPDATE CASCA)

我不知道这是什么意思,我需要做些什么来解决这个问题?

谢谢您:)

转载请注明出处:http://www.yixue91.com/article/20230526/1227508.html