Cannot add or update a child row: a foreign key constraint fails (`db_eshop/#sql-700_1`, CONSTRAINT `FK_member` FOREIGN KEY (`Memberlevel`) REFERENCES `memberlevel` (`ID`))
我用SQLyog建立两个表关系的时候提示这个错误,可能原因是什么,?帮忙看看,
我用SQLyog建立两个表关系的时候提示这个错误,可能原因是什么,?帮忙看看,
`ID` int(4) NOT NULL auto_increment,
`Memberlevel` int(4) NOT NULL,
`LoginName` char(12) default NULL,
`LoginPwd` char(12) default NULL,
`MemberName` char(20) default NULL,
`Phone` char(15) default NULL,
`Address` varchar(100) default NULL,
`Zip` char(10) default NULL,
`RegDate` datetime default NULL,
`LastDate` datetime default NULL,
`LoginTimes` int(4) default NULL,
`EMail` varchar(100) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
CREATE TABLE `memberlevel` (
`ID` int(4) NOT NULL auto_increment,
`LevelName` char(20) default NULL,
`Favourable` int(4) default NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
已贴出