ALTER TABLE `pre_forum_post` ENGINE = INNODB;Err1075 完美解决方法

  • A+
所属分类:未分类

ALTER TABLE `pre_common_member_grouppm` ENGINE = INNODB;
ALTER TABLE `pre_forum_post` ENGINE = INNODB;

[Err] 1075 - Incorrect table definition; there can be only one auto column and it must be defined as

ALTER TABLE `pre_forum_post` ENGINE = INNODB;Err1075 完美解决方法首先在sql下单个运行一下需要修改的数据库条目

ALTER TABLE pre_forum_postposition DROP PRIMARY KEY,ADD PRIMARY KEY(position,tid);
ALTER TABLE pre_common_member_grouppm DROP PRIMARY KEY,ADD PRIMARY KEY(gpmid,uid);
ALTER TABLE pre_forum_post DROP PRIMARY KEY,ADD PRIMARY KEY(position,tid);

再执行

ALTER TABLE `pre_common_member_grouppm` ENGINE = INNODB;
ALTER TABLE `pre_forum_post` ENGINE = INNODB;

完美解决

 

本文为原创,如需转载,请标注本文来自:www.fourye.com四爷技术网

  • 我的微信
  • 这是我的微信扫一扫
  • weinxin
  • 我的微信公众号
  • 我的微信公众号扫一扫
  • weinxin