How To Alter/Change InnoDB to MyISAM

"What? MySQL Fulltext Search is not working!"
Well, this is what I thought before. I used to have MyISAM tables when developing an application. I never thought about table types.

I then realized that I was using InnoDB table type where MySQL Fulltext search is not working.  So I had to alter the table from InnoDB to MyISAM.


Here's the code:

ALTER TABLE table_name ENGINE = MyISAM;

table_name
-It is the name of your table.

And that solved my problem! :)

In case that you want to get it back to InnoDB, here's the code:

ALTER TABLE table_name ENGINE = InnoDB;

If you have any inquiries/comments/questions/suggestions, just comment to this post. :)

Tweet

For FREE programming tutorials, click the red button below and subscribe! :)

SUBSCRIBE to Receive Ninja Codes