MySQL Full text search commands

1. Moving existing table from one engine to another-

ALTER TABLE table_name ENGINE=engine_name;

Engine names could be -> InnoDB, MyISAM

For further reference, browse thru “A fast and furious guide to MySQL database engines“

2. “MySQL Indexs” a glimpse.

3. Creating Full Text index and playing with it “How it works“

4. Creating Full Text index on an existing table-

CREATE FULLTEXT INDEX index_name ON table_name (column_names);

5. Implementing Full Text search in Django using MySQL - “Extending Django’s database API to include full-text search“

Posted via web from Varun Bansal’s weblog

Advertisement