In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
2025-03-31 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >
Share
Shulou(Shulou.com)06/01 Report--
View the index status on the table:
SHOW INDEX returns table index information.
SHOW KEYS and SHOW INDEXES are synonyms for SHOW INDEX.
Syntax:
Show {index | indexes} from table_name [from db_name] [where expr]
The following fields are returned by SHOW INDEX.
FieldDescriptionTableTable nameNon_unique1 if the index permits duplicate values, 0 if values must be unique.Key_nameIndex name. The primary key is always named PRIMARY.Seq_in_indexThe column's sequence in the index, beginning with 1.Column_nameColumn name.CollationEither A, if the column is sorted in ascending order in the index, or NULL if it's not sorted.CardinalityEstimated number of unique values in the index. The cardinality statistics are calculated at various times, and can help the optimizer make improved decisions.Sub_partNULL if the entire column is included in the index, or the number of included characters if not.PackedNULL if the index is not packed, otherwise how the index is packed.NullNULL if NULL values are permitted in the column, an empty string if NULL's are not permitted.Index_typeThe index type, which can be BTREE, FULLTEXT, HASH or RTREE. See Storage Engine Index Types.CommentOther information, such as whether the index is disabled.Index_commentContents of the COMMENT attribute when the index was created.
Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.
Views: 261
*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.