WampServer

Hi

I was trying an example for text based searching in mysql provided by wamp. I created a table with two columns id and data, id being the primary key.

After that when I am executing the command :
ALTER TABLE reviews ADD FULLTEXT INDEX (data);

it is showing the following error :
ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes

I am not able to understand why this is happening. I want to know whether mysql in wamp come with this feature in mysql or not. If not, how to make my table in mysql support FULLTEXT INDEXES. If yes, please tell me how to support this feature in my table.

I appreciate your immediate response.

Thank you,

chaitanya

Hi,

Which type of table did you create? If you use MySQL Administrator to create a table, it creates by default a table using the InnoDB Storage Engine which does not support FULLTEXT indexes, whereas MyISAM tables support them. See the details at [dev.mysql.com] and [dev.mysql.com].

Regards,



toivo
Sydney, Australia