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;



 

0 comments:

Blog Archive

Total Pageviews

Popular Posts