關(guān)于create table命令上的重復(fù)鍵，我收到1022錯(cuò)誤。看完查詢后，我不知道在哪里進(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'

總結(jié)

以上是生活随笔為你收集整理的mysql不能写重复键_错误1022-无法写入；表中的重复键的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。