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
- -- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------
- -- File: INDEXES.SQL
- -- Created: 6/29/2004
- -- Modified: 6/29/2004
- -- Purpose: Create IVC table indexes
- -- Dependencies: MySQL 3.23+ Database
- -- Privacy Scope: SQL file. Be sure to render lockdown on /sql folder
- to prevent viewing/downloading of this script
- -- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
- ALTER TABLE image ADD INDEX ix_image_path (image_path);
- ALTER TABLE image ADD FULLTEXT ix_search (image_name, image_alt,
- image_location_city, image_location_state, image_location_country);
- ALTER TABLE album ADD INDEX ix_album_name (album_name);
- ALTER TABLE department ADD INDEX ix_department_name (department_name);
- ALTER TABLE department ADD INDEX ix_department_parent_id
- (department_parent_id);
- ALTER TABLE person ADD INDEX ix_department_id (department_id);
- ALTER TABLE person ADD FULLTEXT ix_search (first_name, last_name);
- ALTER TABLE keyword ADD FULLTEXT ix_search (keyword_name);
- ALTER TABLE event ADD FULLTEXT ix_search (event_name);
- ALTER TABLE placement ADD FULLTEXT ix_search (placement_name);
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