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
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.
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
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 (
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