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四爷技术网