左右不逢缘 发表于 2024-2-17 20:26:36

3.4升级到3.5出现 there can be only one auto column and it must be defined as a key New

在转换主题分表pre_forum_post_1表的时候出现

(1075) Incorrect table definition; there can be only one auto column and it must be defined as a keyALTER TABLE forum_post_1 ENGINE=InnoDB;

查看表结构

position字段有个
AUTO_INCREMENT值如图,但是这个值在pre_forum_post也是有的,转换后会自动删除这值。而分表pre_forum_post_1直接提示错误。




我知道答案 回答被采纳将会获得1 贡献 已有0人回答
页: [1]
查看完整版本: 3.4升级到3.5出现 there can be only one auto column and it must be defined as a key New

创宇盾启航版免费网站防御网站加速服务