Jump to content


Photo

Trying to ALTER Table for a FULLTEXT index


  • Please log in to reply
No replies to this topic

#1 trigger

trigger
  • Members
  • Pip
  • Newbie
  • 1 posts

Posted 23 July 2003 - 03:45 PM

Can someone help me? I\'m getting a MSYQL 1064 error. The MYSQL code is
ALTER TABLE `tickets` ADD FULLTEXT FULLTEXT (problemWith,issue,fix)
I\'m using MYSQL-Front 2.4 if anyone knows about that. The \'problemWith\' field is a varchar, and the \'issue\' and \'fix\' fields are text fields. It is an MyISAM table type too.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users