3.4升级到3.5出现 there can be only one auto column and it must be defined as a key
2024/11/06 02:39:58
在转换主题分表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;
查看表结构
如图，但是这个值在pre_forum_post也是有的，转换后会自动删除这值。而分表pre_forum_post_1直接提示错误。
我知道答案 回答被采纳将会获得1 贡献 已有2人回答
(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值 |
我知道答案 回答被采纳将会获得1 贡献 已有2人回答