Hi!
On Apr 09, Mike<mickalo>Blezien wrote:
> I posted a couple problems regarding the use of the FULLTEXT indexing and a
> search query problem, but never got any responses. So maybe some one may shed
> some lite on setting up a table with the FULLTEXT index.
>
> I've read thru the MySQL docs on this and it's not real clear. When setting up a
> table, when an utilizing a FULLTEXT index. When creating the table, can it only
> have to columns or can the table have more then two columns:
>
> CREATE TABLE search
> ( id int(8),
> title varchar(200),
> keywords TEXT,
> category char(2)
> FULLTEXT (title,keywords)
> )
>
> Is this correct or can you only have two columns when using the FULLTEXT
> Indexing??
The above is correct.
By the way, you was able to find it yourself - thus saving
your time - by trying to execute the SQL statement above.
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php