Converting my MyISAM to InnoDB

I have no record in table. I got this error when i Converting my MyISAM to InnoDB

SQL query: Edit

ALTER TABLE `vocabulary` ENGINE = InnoDB

MySQL said: Documentation

#1214 - The used table type doesn't support FULLTEXT indexes

Table structure for table vocabulary

CREATE TABLE IF NOT EXISTS vocabulary ( id int(10) unsigned NOT NULL AUTO_INCREMENT, usr char(10) NOT NULL, word char(10) NOT NULL, meaning char(10) NOT NULL, synonym char(10) NOT NULL, Date char(10) NOT NULL, PRIMARY KEY ( id ), FULLTEXT KEY usr ( usr ) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

---

in MySQL only MyISAM storage engine supports full text indexes

Innodb will not support full text indexes

so in order to convert the table use

  alter table vocabulary drop key usr;

  alter table vocabulary engine=innodb;

链接地址: http://www.djcxy.com/p/59692.html

上一篇: 使用限制和where子句做分页

下一篇: 将我的MyISAM转换为InnoDB