|
错误提示 : (1031) Table storage engine for '#sql-b28_e5' doesn't have this option
解决办法:
建一个新表, 数据挪过去
CREATE TABLE pre_common_member_grouppm_new (
uid MEDIUMINT (8) UNSIGNED NOT NULL DEFAULT '0',
gpmid SMALLINT (6) UNSIGNED NOT NULL AUTO_INCREMENT,
`status` TINYINT (1) NOT NULL DEFAULT '0',
dateline INT (10) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (gpmid)
) ENGINE=InnoDB DEFAULT CHARSET = utf8;
INSERT INTO pre_common_member_grouppm_new SELECT * FROM pre_common_member_grouppm;
RENAME TABLE pre_common_member_grouppm TO pre_common_member_grouppm_bak
RENAME TABLE pre_common_member_grouppm_new TO pre_common_member_grouppm
|
|