How to find whether a key is fulltext

2002-10-01 Thread Insanely Great
Greetings.. I am doing show keys from db.tablename but how can I know whether the key if fulltext or not. I get to know the key is unique or not by checking Not_Unique column in the returned resultset. How to find a key is fulltext. Thx Insane sql,query,mysql

re: How to find whether a key is fulltext

2002-10-01 Thread Victoria Reznichenko
Insanely, Tuesday, October 01, 2002, 3:49:10 PM, you wrote: IG I am doing show keys from db.tablename but how can I know whether the key if IG fulltext or not. I get to know the key is unique or not by checking IG Not_Unique column in the returned resultset. IG How to find a key is fulltext.

Re: How to find whether a key is fulltext

2002-10-01 Thread Paul DuBois
At 18:19 +0530 10/1/02, Insanely Great wrote: Greetings.. I am doing show keys from db.tablename but how can I know whether the key if fulltext or not. I get to know the key is unique or not by checking Not_Unique column in the returned resultset. SHOW KEYS shows this information in the

Re: How to find whether a key is fulltext

2002-10-01 Thread Insanely Great
Greetinsg... When I am doing show index from db.tablename, the columns I am gettings are - Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Comment Which one of these will tell me whether a key is fulltext or not. Rgds Ritesh SQLyog (

re: Re: How to find whether a key is fulltext

2002-10-01 Thread Egor Egorov
Insanely, Tuesday, October 01, 2002, 6:22:47 PM, you wrote: IG When I am doing IG show index from db.tablename, the columns I am gettings are - IG Table IG Non_unique IG Key_name IG Seq_in_index IG Column_name IG Collation IG Cardinality IG Sub_part IG Packed IG Comment IG Which one of these