By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,677 Members | 1,060 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,677 IT Pros & Developers. It's quick & easy.

How to create fulltext indexes in MySQL 3.23.58?

P: n/a
Retracing my problem leads me to believe I never successfully created
fulltext indexes for MySQL 3.23.58 MyISAM tables. I went to the MySQL
manual and was able - or so I thought - to create them, however, my
fulltext search queries fail in 3.23.58 but the exact queries (with
same data) work perfectly in 4.0.10.

Expand|Select|Wrap|Line Numbers
  1. -- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
  2. --    File: INDEXES.SQL
  3. --    Created: 6/29/2004
  4. --    Modified: 6/29/2004
  5. --    Purpose: Create IVC table indexes
  6. --    Dependencies: MySQL 3.23+ Database
  7. --    Privacy Scope: SQL file.  Be sure to render lockdown on /sql folder
  8. to prevent viewing/downloading of this script
  9. -- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
  10.  
  11. ALTER TABLE image ADD INDEX ix_image_path (image_path);
  12. ALTER TABLE image ADD FULLTEXT ix_search (image_name, image_alt,
  13. image_location_city, image_location_state, image_location_country);
  14.  
  15. ALTER TABLE album ADD INDEX ix_album_name (album_name);
  16.  
  17. ALTER TABLE department ADD INDEX ix_department_name (department_name);
  18. ALTER TABLE department ADD INDEX ix_department_parent_id
  19. (department_parent_id);
  20.  
  21. ALTER TABLE person ADD INDEX ix_department_id (department_id);
  22. ALTER TABLE person ADD FULLTEXT ix_search (first_name, last_name);
  23.  
  24. ALTER TABLE keyword ADD FULLTEXT ix_search (keyword_name);
  25.  
  26. ALTER TABLE event ADD FULLTEXT ix_search (event_name);
  27.  
  28. ALTER TABLE placement ADD FULLTEXT ix_search (placement_name);
  29.  
This results in what I thought would be fulltext indexes for each
table called "ix_search" but what it creates are indexes with COMMENTS
of "fulltext", not INDEX_TYPE of "FULLTEXT".

Could someone show me how to do this right for 3.23.58?

Thanx
Phil
Jul 20 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.