10MMYSQL 版本:5.7.44
问题描述:
创建表提示 1022 - Can’t write; duplicate key in table ‘act_ge_bytearray’
建表语句如下:
DROP TABLE IF EXISTS act_ge_bytearray;
CREATE TABLE act_ge_bytearray (
ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
REV_ int(11) NULL DEFAULT NULL,
NAME_ varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
DEPLOYMENT_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
BYTES_ longblob NULL,
GENERATED_ tinyint(4) NULL DEFAULT NULL,
PRIMARY KEY (ID_) USING BTREE,
INDEX ACT_FK_BYTEARR_DEPL(DEPLOYMENT_ID_) USING BTREE,
CONSTRAINT ACT_FK_BYTEARR_DEPL FOREIGN KEY (DEPLOYMENT_ID_) REFERENCES act_re_deployment (ID_) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;
但是我查询了索引和约束,也没有发现重复的,哪位老师指点下
墨值悬赏

评论

