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 o
://www.webyog.com )
The Definative GUI for MySQL
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Insanely Great" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, October 01, 2002 7:16 PM
Subject: Re: How to find whether a key is fulltex
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 Ind
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.
