關(guān)于create table命令上的重復(fù)鍵,我收到1022錯誤??赐瓴樵兒?,我不知道在哪里進(jìn)行復(fù)制。有人可以看到嗎?SQL query:-- ------------------------------------------------------- Table `apptwo`.`usercircle`-- -----------------------------------------------------CREATE TABLE IF NOT EXISTS `apptwo`.`usercircle` ( `idUserCircle` MEDIUMINT NOT NULL , `userId` MEDIUMINT NULL , `circleId` MEDIUMINT NULL , `authUser` BINARY NULL , `authOwner` BINARY NULL , `startDate` DATETIME NULL , `endDate` DATETIME NULL ,PRIMARY KEY ( `idUserCircle` ) ,INDEX `iduser_idx` ( `userId` ASC ) ,INDEX `idcategory_idx` ( `circleId` ASC ) ,CONSTRAINT `iduser` FOREIGN KEY ( `userId` ) REFERENCES `apptwo`.`user` (`idUser`) ON DELETE NO ACTION ON UPDATE NO ACTION ,CONSTRAINT `idcategory` FOREIGN KEY ( `circleId` ) REFERENCES `apptwo`.`circle` (`idCircle`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = INNODB;MySQL said: Documentation#1022 - Can't write; duplicate key in table 'usercircle'
錯誤1022-無法寫入;表中的重復(fù)鍵
慕田峪4524236
2019-11-13 14:25:53