Jump to content

Trying to ALTER Table for a FULLTEXT index


trigger

Recommended Posts

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.

Link to comment
https://forums.phpfreaks.com/topic/769-trying-to-alter-table-for-a-fulltext-index/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.