Wow! I got this error when i am creating a below table with FULLTEXT indices. The reason for this exception is "Full-Text Search is supported only with MyISAM Engine before MySQL version 5.6"
CREATE TABLE comment
(
commentid int unsigned NOT NULL AUTO_INCREMENT,
userid int unsigned NOT NULL,
comment text NOT NULL,
PRIMARY KEY (commentid),
FULLTEXT KEY comment (comment)
) ;
Solution:
You specify MyISAM engine at end of the table creation.
CREATE TABLE comment
(
commentid int unsigned NOT NULL AUTO_INCREMENT,
userid int unsigned NOT NULL,
comment text NOT NULL,
PRIMARY KEY (commentid),
FULLTEXT KEY comment (comment)
) ENGINE=MyISAM;
CREATE TABLE comment
(
commentid int unsigned NOT NULL AUTO_INCREMENT,
userid int unsigned NOT NULL,
comment text NOT NULL,
PRIMARY KEY (commentid),
FULLTEXT KEY comment (comment)
) ;
Solution:
You specify MyISAM engine at end of the table creation.
CREATE TABLE comment
(
commentid int unsigned NOT NULL AUTO_INCREMENT,
userid int unsigned NOT NULL,
comment text NOT NULL,
PRIMARY KEY (commentid),
FULLTEXT KEY comment (comment)
) ENGINE=MyISAM;
0 comments:
Post a Comment