Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

problem in creating table with FULLTEXT KEY index

 
S.R.K.Vivek Raju
Ranch Hand
Posts: 58
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all

I am using mysql-4.1.11-nt stable version, now when i try to create a table with the FULLTEXT KEY index it gives an error saying

ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes.

I am relatively new to MySQL could antone tell me what does this mean

The table am creating is as follows:--
CREATE TABLE `contact_us` (
`id` int(10) unsigned NOT NULL auto_increment,
`firstname` varchar(45) default NULL,
`lastname` varchar(45) default NULL,
`middleinitial` char(1) default NULL,
`id_group` int(10) unsigned NOT NULL default '0',
`address` varchar(100) default NULL,
`city` varchar(45) default NULL,
`state` varchar(45) default NULL,
`userstate` varchar(45) default NULL,
`country` varchar(45) default NULL,
`zipcode` varchar(45) default NULL,
`business_phone` varchar(45) default NULL,
`home_phone` varchar(45) default NULL,
`mobile_phone` varchar(45) default NULL,
`email` varchar(45) default NULL,
`alternate_email` varchar(45) default NULL,
`im` varchar(45) default NULL,
`alternate_im` varchar(45) default NULL,
`website` varchar(100) default NULL,
`voip` varchar(45) default NULL,
`education` varchar(100) default NULL,
`company` varchar(100) default NULL,
`hobbies` varchar(100) default NULL,
`other_tags` varchar(100) default NULL,
PRIMARY KEY (`id`),
KEY `idx_name` (`firstname`,`lastname`),
KEY `idx_group` (`id_group`),
KEY `idx_city` (`city`),
KEY `idx_country` (`country`),
FULLTEXT KEY `idx_address` (`address`),
FULLTEXT KEY `idx_education` (`education`),
FULLTEXT KEY `idx_company` (`company`),
FULLTEXT KEY `idx_hobbies` (`hobbies`),
FULLTEXT KEY `idx_other_tags` (`other_tags`)
)
*************************************************************************
If the FULLTEXT is removed it gets created.

Thanks

With Regards
S.R.K.Vivek Raju.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34095
337
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Vivek,
According to the syntax reference, you just write "fulltext", rather than "fulltext key".
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic