On Mon, 20 Jan 2003, David T-G wrote: > OK; here's some code (I didn't want to waste time posting junk, but > perhaps it's applicable here after all. Thanks for the couple of > responses so far! > > # a particular piece > create table pieces > ( > # ID number > id smallint unsigned not null default 0 auto_increment primary key , > title char(50) , > index (title) , > words text (4095) , > fulltext index (words(4095)) > ) ;
David, try the following: create table pieces ( id smallint unsigned not null auto_increment primary key, title varchar(50), words text, key (title(16)), fulltext (words) ) TYPE=MYISAM; Are you sure that smallint is enough for your index? Do you really need to index the full title? Thomas Spahni -- filter: mysql, query --------------------------------------------------------------------- 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