暂无图片
只此无云
2024-12-17
mysql 创建表提示key重复
暂无图片 10M

MYSQL 版本: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;

但是我查询了索引和约束,也没有发现重复的,哪位老师指点下

收藏
1条回答
默认
最新
只此无云

解决了,我把CONSTRAINT ACT_FK_BYTEARR_DEPL FOREIGN KEY
改为
CONSTRAINT ACT_FK_BYTEARR_DEPL_NEW FOREIGN KEY
就可以了。

暂无图片 评论
暂无图片 有用 1
暂无图片
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏