mysql 1022错误_mysql – 错误1022 – 无法写入;在表中重复键

我得到一个1022错误关于重复键的create table命令。看过这个查询，我不明白重复发生在哪里。其他人可以看到吗？

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'

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！