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'
| | NULL||
| Created | datetime| YES | | NULL||
| Body| text| YES | | NULL||
+-+-+--+-+-++
-Original Message-
From: Clemson Chan [mailto:[EMAIL
' 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
-
From: Mark Matthews [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 06, 2002 3:27 PM
To: Clemson Chan
Cc: Mysql
Subject: Re: interesting find
Clemson Chan wrote:
The MySQL 3.23.52-nt (FTP image) I just downloaded from USA [UUNET]
(appointed by MySQL.com).
http://www.mysql.com/downloads