SELECT * FROM `STATISTICS`
|
TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | NON_UNIQUE | INDEX_SCHEMA | INDEX_NAME | SEQ_IN_INDEX | COLUMN_NAME | COLLATION | CARDINALITY | SUB_PART | PACKED | NULLABLE | INDEX_TYPE | COMMENT | INDEX_COMMENT | IS_VISIBLE | EXPRESSION | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
def | mysql | columns_priv | 0 | mysql | PRIMARY | 1 | Host | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | mysql | columns_priv | 0 | mysql | PRIMARY | 2 | Db | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | mysql | columns_priv | 0 | mysql | PRIMARY | 3 | User | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | mysql | columns_priv | 0 | mysql | PRIMARY | 4 | Table_name | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | mysql | columns_priv | 0 | mysql | PRIMARY | 5 | Column_name | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | mysql | component | 0 | mysql | PRIMARY | 1 | component_id | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | mysql | db | 0 | mysql | PRIMARY | 1 | Host | A | 2 | NULL | NULL | BTREE | YES | NULL | ||||
def | mysql | db | 0 | mysql | PRIMARY | 2 | Db | A | 5 | NULL | NULL | BTREE | YES | NULL | ||||
def | mysql | db | 0 | mysql | PRIMARY | 3 | User | A | 5 | NULL | NULL | BTREE | YES | NULL | ||||
def | mysql | db | 1 | mysql | User | 1 | User | A | 5 | NULL | NULL | BTREE | YES | NULL | ||||
def | mysql | default_roles | 0 | mysql | PRIMARY | 1 | HOST | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | mysql | default_roles | 0 | mysql | PRIMARY | 2 | USER | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | mysql | default_roles | 0 | mysql | PRIMARY | 3 | DEFAULT_ROLE_HOST | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | mysql | default_roles | 0 | mysql | PRIMARY | 4 | DEFAULT_ROLE_USER | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | mysql | engine_cost | 0 | mysql | PRIMARY | 1 | cost_name | A | 2 | NULL | NULL | BTREE | YES | NULL | ||||
def | mysql | engine_cost | 0 | mysql | PRIMARY | 2 | engine_name | A | 2 | NULL | NULL | BTREE | YES | NULL | ||||
def | mysql | engine_cost | 0 | mysql | PRIMARY | 3 | device_type | A | 2 | NULL | NULL | BTREE | YES | NULL | ||||
def | mysql | func | 0 | mysql | PRIMARY | 1 | name | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | mysql | global_grants | 0 | mysql | PRIMARY | 1 | USER | A | 1 | NULL | NULL | BTREE | YES | NULL | ||||
def | mysql | global_grants | 0 | mysql | PRIMARY | 2 | HOST | A | 4 | NULL | NULL | BTREE | YES | NULL | ||||
def | mysql | global_grants | 0 | mysql | PRIMARY | 3 | PRIV | A | 76 | NULL | NULL | BTREE | YES | NULL | ||||
def | mysql | gtid_executed | 0 | mysql | PRIMARY | 1 | source_uuid | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | mysql | gtid_executed | 0 | mysql | PRIMARY | 2 | interval_start | A | 0 | NULL | NULL | BTREE | YES | NULL | ||||
def | mysql | help_category | 0 | mysql | name | 1 | name | A | 44 | NULL | NULL | BTREE | YES | NULL | ||||
def | mysql | help_category | 0 | mysql | PRIMARY | 1 | help_category_id | A | 44 | NULL | NULL | BTREE | YES | NULL |
|