Re: fulltext indices

[Brent Baisley]

First, full text indices have nothing to do with importing the data, 
it's just a special type of indexing for searching. The reason you got 
several rows is that you probably did not specify delimiters. Thus, 
every time a return was encountered, a new record was created because 
return is the default record delimiter for imports. Read the manual for 
loading data, you can specify any delimiter for fields and records.
For instance, for importing full documents I use ^^ for field 
delimiters and ~~ for record delimiters.

On Mar 24, 2004, at 5:53 PM, Brandon Carter wrote:

Is it possible to fit an entire article (say, a newspaper article) 
into one cell of a MySQL database?  When I tried load data local 
infile the file was imported into several rows!  Perhaps I just don't 
understand the use of a fulltext index.

--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]