jjzjj

mysql错误1451

我有代码为1451的mysql错误。Cannotdeleteorupdateaparentrow:aforeignkeyconstraintfails(online_store_admin.osa_admin_logs,CONSTRAINTfk_admins_logsFOREIGNKEY(aid)REFERENCESosa_admins(aid))这里是sql语句:droptableifexistsosa_admins;createtableifnotexistsosa_admins(aidintunsignednotnullauto_increment,uidvarchar(50)n

mysql - 错误 1451 : 1451: Cannot delete or update a parent row: a foreign key constraint fails

我一直在寻找这个错误,偶然发现了几个性质相同的问题,但据我了解,他们似乎关心更新问题。我的源于删除条目。我的table是这样组成的:CREATETABLE`product`(`product_id`mediumint(8)unsignedNOTNULLAUTO_INCREMENTCOMMENT'representsuniqueidentifierforeveryexistingproducts',`code`varchar(20)NOTNULL,`name`varchar(45)NOTNULLCOMMENT'description',`price`decimal(11,4)NOTNUL