RE: help needed to create index

2005-05-25 Thread Peter Normann
Asha wrote: Is there a physical limitation in the InnoDb table structure as to why it can't support FullText indexes? http://dev.mysql.com/doc/mysql/en/fulltext-restrictions.html http://dev.mysql.com/doc/mysql/en/innodb-restrictions.html Peter Normann -- MySQL General Mailing List For

help needed to create index

2005-05-24 Thread Asha
creating an index is necessary for fulltext search. and when i say create fulltext index search_index on sometable(column1,column2) i get an error messg like Error: The used table type doesn't support FULLTEXT indexes Why doesn't InnoDb support FullText indexes? Is there a physical