hello,
i've been having some trouble with this lately. i can't seem to use the alter table syntax to add a fulltext index. im using myql 3.23.33. the sql im using is:
ALTER TABLE book ADD FULLTEXT title;
MySQL is saying:
ERROR 1064: You have an error in your SQL syntax near '' at line 1
the only way i've got this to work in the past is to create a new table with the FULLTEXT index at that time. any suggestions?
-paul
<!-- m --><a class="postlink" href="http://xhawk.net">http://xhawk.net</a><!-- m -->
i've been having some trouble with this lately. i can't seem to use the alter table syntax to add a fulltext index. im using myql 3.23.33. the sql im using is:
ALTER TABLE book ADD FULLTEXT title;
MySQL is saying:
ERROR 1064: You have an error in your SQL syntax near '' at line 1
the only way i've got this to work in the past is to create a new table with the FULLTEXT index at that time. any suggestions?
-paul
<!-- m --><a class="postlink" href="http://xhawk.net">http://xhawk.net</a><!-- m -->