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 def
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.
--bhcesl
Do you Yahoo!?
Yahoo! F
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.
--bhcesl
Do you Yahoo!?
Yahoo! Finance Tax Center -
times when creating the
index. For example:
create fulltext index test
on TxKeywords
(Title,Title,Description);
seems to have roughly the desired effect, but I don't exactly
understand what it's doing, and I don't know if this is supported
behavior, or if might go