Jump to content

Archived

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

trigger

Trying to ALTER Table for a FULLTEXT index

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.

Share this post


Link to post
Share on other sites

×

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.