-
FULLTEXT indexing
Hi all,
I have table called 'profile' i have altered the table
ALTER TABLE profile ADD FULLTEXT ( oname , etc...);
I have 14 cols in the alter list - (oname, etc..)
This creates an index that appears to be empty.
My dbase has 1800 rows the cardinality says none.
I'm using MySQL 3.23.56
Any ideas where I may be goin wrong?
If I can get this working will I have to reapply the process each time a change happens manually or does it update automatically?
Thanks in advance
Chris
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|