hello!
When I attempt to create a fulltext-index with the following code
ALTER TABLE press ADD FULLTEXT ruffsig (preamble)
everything seems fine. And the SHOW CREATE TABLE results ( see below )
seems
fine too!
Yet when I run a SHOW INDEX FROM press, the "sub_part" value is 1, and
the comment field does not include a "Fulltext" note... How come?!!?
Server: mySQL 3.32-beta
create table press(id int(16) unsigned default NULL auto_increment,
date date not null default '0000-00-00',
header varchar(130) not null default '',
preamble text not null,
txt text not null,
pdf int(16) unsigned not null default '0',
image int(16) unsigned not null default '0',
primary key (id),
key date(date),
fulltext key ruffsig(preamble)
) type=MyISAM
/ David
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
