CREATE TABLE `test`.`friendlist` (
`Lid` INT NOT NULL,
`Pid` INT NOT NULL,
`Fid` INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`Fid`),
INDEX `Pid_idx` (`Pid` ASC),
INDEX `Lid_idx` (`Lid` ASC, `Pid` ASC),
CONSTRAINT `Lid`
FOREIGN KEY (`Lid` , `Pid`)
REFERENCES `test`.`loginauthentication` (`Lid` , `Pid`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `Pid`
FOREIGN KEY (`Pid`)
REFERENCES `test`.`person` (`Pid`)
ON DELETE NO ACTION
ON UPDATE NO ACTION);
操作失败:将SQL脚本应用于数据库时出错。错误1215:无法添加外键约束SQL语句:
我尝试执行您的SQL,发现在表loginauthentication中存在列Pid代理,但是我添加了列并再次运行您的SQL,它起作用了!
ALTER TABLE `loginauthentication`ADD COLUMN `Pid` int(11) NULL AFTER `Lid`
[SQL] CREATE TABLE `friendlist` (
`Lid` INT NOT NULL,
`Pid` INT NOT NULL,
`Fid` INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`Fid`),
INDEX `Pid_idx` (`Pid` ASC),
INDEX `Lid_idx` (`Lid` ASC, `Pid` ASC),
CONSTRAINT `Lid`
FOREIGN KEY (`Lid` , `Pid`)
REFERENCES `loginauthentication` (`Lid` , `Pid`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `Pid`
FOREIGN KEY (`Pid`)
REFERENCES `person` (`Pid`)
ON DELETE NO ACTION
ON UPDATE NO ACTION);
Affected rows: 0
Time: 0.179ms
祝你好运!
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句