> -----Original Message----- > From: Salada, Duncan [mailto:[EMAIL PROTECTED]] > Sent: 28. januar 2003 20:40 > To: '[EMAIL PROTECTED]' > Subject: problems creating fulltext index > > > Hello everyone, > > I'm running Ver 8.39 Distrib 4.0.9-gamma, for intel-linux on > i686. I'm > trying to create a fulltext index on an existing myisam table > and running up > against an error. From what I can tell, I'm using the alter > table command > correctly, but I keep getting errno 140. Can anyone point > out my error? > > mysql> alter table materials add fulltext title > (title,variant_title,ss_title,term_1,term_2,term_3,term_4, > term_5,abstract,notes,personal_name_1,personal_name_2,personal > _name_3,person > al_name_4, > personal_name_5,personal_name_6); > > ERROR 1005: Can't create table './lincs/#sql-6d12_7.frm' (errno: 140)
Have you tried using "create index"? >From the documentation (http://www.mysql.com/doc/en/CREATE_INDEX.html): CREATE [UNIQUE|FULLTEXT] INDEX index_name ON tbl_name (col_name[(length)],... ) So it would become CREATE FULLTEXT INDEX title_idx ON materials (title,variant_title,ss_title,term_1,term_2,term_3,term_4,term_5,abstract,no tes,personal_name_1,personal_name_2,personal_name_3,person_al_name_4, personal_name_5,personal_name_); Regards Erlend Stromsvik _______________ 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