Hi there, I am pretty new on MySQL. I am running a website, it needs a
fulltext search on the message board.
The message board table is setup without the fulltext column now. So when I
ALTER TABLE to add a new column FULLTEXT(title, body)? The index will be
created?
In my table, the 'body'
PROTECTED]]
Sent: Friday, September 06, 2002 12:06 PM
To: Mysql
Subject: FULLTEXT search questions
Hi there, I am pretty new on MySQL. I am running a website, it needs a
fulltext search on the message board.
The message board table is setup without the fulltext column now. So when I
ALTER TABLE to add
Cc: Clemson Chan
Subject: RE: FULLTEXT search questions
What is the following error? how do I fix it?
Thanks,
--Clemson
mysql alter table message1 add FULLTEXT (Title,Body);
ERROR 1121: Column 'Title' is used with UNIQUE or INDEX but is not defined
as NOT NULL
mysql desc message1
' can't be used in key specification with the
used table type
-Original Message-
From: Clemson Chan [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 06, 2002 2:13 PM
To: Mysql
Cc: Clemson Chan
Subject: RE: FULLTEXT search questions
What is the following error? how do I fix it?
Thanks