How to find whether a key is fulltext
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 - 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
re: How to find whether a key is fulltext
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. Use SHOW INDEX FROM table_name http://www.mysql.com/doc/en/SHOW.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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
Re: How to find whether 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 Index_type column. How to find a key is fulltext. Thx Insane sql,query,mysql - 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
Re: How to find whether a key is fulltext
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 ( http://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 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 Index_type column. How to find a key is fulltext. Thx Insane sql,query,mysql - 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 - 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
re: Re: How to find whether a key is fulltext
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 will tell me whether a key is fulltext or not. Index_type contains this info. For example mysql show index from articles\G *** 1. row *** Table: articles Non_unique: 0 Key_name: PRIMARY Seq_in_index: 1 Column_name: id Collation: A Cardinality: NULL Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: *** 2. row *** Table: articles Non_unique: 1 Key_name: title Seq_in_index: 1 Column_name: title Collation: A Cardinality: NULL Sub_part: NULL Packed: NULL Null: YES Index_type: FULLTEXT Comment: *** 3. row *** Table: articles Non_unique: 1 Key_name: title Seq_in_index: 2 Column_name: body Collation: A Cardinality: NULL Sub_part: 1 Packed: NULL Null: YES Index_type: FULLTEXT Comment: 3 rows in set (0.00 sec) -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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