MySQL Forums
Forum List  »  Full-Text Search

I cant run this full text search query to create table
Posted by: sipatha ncube
Date: January 09, 2006 06:03AM

Hie guyz. I am new and would like to use the full text search capablility of MySQL for my project. To start i was just having a look at the full text search documentation. Pardon me i'm also learning indexing as well.

i tried running the following query on MySQL to just test some of the queries in the manual (http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html). I tried the example on the full text search page

-----

CREATE TABLE articles (
id INT UNSIGNED NOT NULL PRIMARY KEY,
title VARCHAR(200),
body TEXT,
FULLTEXT (title,body)
);

--------
but got this
--------

mysql> use test
Database changed
mysql> select version();
+-----------+
| version() |
+-----------+
| 5.0.15-nt |
+-----------+
1 row in set (0.00 sec)

mysql> CREATE TABLE articles (
-> id INT UNSIGNED NOT NULL PRIMARY KEY,
-> title VARCHAR(200),
-> body TEXT,
-> FULLTEXT (title,body)
-> );
ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes
---------

i read that full text search is only supported on tables with MyISAM. Can anyone please help. A link or two will be also good.

Thanks in advance

Options: ReplyQuote


Subject
Views
Written By
Posted
I cant run this full text search query to create table
4555
January 09, 2006 06:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.