Operation failed: There was an error while applying the SQL script to the database.
Executing:
ALTER TABLE `xq`.`manageinfo` 
ADD CONSTRAINT `idmanagetype`
  FOREIGN KEY (`idmanagetype`)
  REFERENCES `xq`.`managetype` (`idmanagetype`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;

ERROR 1826: Duplicate foreign key constraint name 'idmanagetype'
SQL Statement:
ALTER TABLE `xq`.`manageinfo` 
ADD CONSTRAINT `idmanagetype`
  FOREIGN KEY (`idmanagetype`)
  REFERENCES `xq`.`managetype` (`idmanagetype`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION

1826 没有取消线程。 …这个。。
原因:是因为我在之前已经加过一个名称为idmanagetype外键索引了 ,如果重复则报错,我再名称后面加一个1成功了。

ALTER TABLE `xq`.`manageinfo` 
ADD INDEX `idmanagetype1_idx` (`idmanagetype` ASC) VISIBLE;
;
ALTER TABLE `xq`.`manageinfo` 
ADD CONSTRAINT `idmanagetype1`
  FOREIGN KEY (`idmanagetype`)
  REFERENCES `xq`.`managetype` (`idmanagetype`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;

Logo

腾讯云面向开发者汇聚海量精品云计算使用和开发经验,营造开放的云计算技术生态圈。

更多推荐