SELECT * FROM `STATISTICS` ORDER BY `COLLATION` ASC
Filtrer les lignes: |
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
def | mysql | func | 0 | mysql | PRIMARY | 1 | name | A | 0 | NULL | NULL | BTREE | ||||
def | mysql | help_topic | 0 | mysql | name | 1 | name | A | 752 | NULL | NULL | BTREE | ||||
def | sprotest | sales | 0 | sprotest | PRIMARY | 1 | id | A | 2955 | NULL | NULL | BTREE | ||||
def | mysql | proc | 0 | mysql | PRIMARY | 1 | db | A | NULL | NULL | NULL | BTREE | ||||
def | mysql | columns_priv | 0 | mysql | PRIMARY | 5 | Column_name | A | 0 | NULL | NULL | BTREE | ||||
def | mysql | global_priv | 0 | mysql | PRIMARY | 2 | User | A | 4 | NULL | NULL | BTREE | ||||
def | mysql | index_stats | 0 | mysql | PRIMARY | 2 | table_name | A | NULL | NULL | NULL | BTREE | ||||
def | sprotest | suppliers | 0 | sprotest | PRIMARY | 1 | id | A | 0 | NULL | NULL | BTREE | ||||
def | mysql | proc | 0 | mysql | PRIMARY | 3 | type | A | 0 | NULL | NULL | BTREE | ||||
def | mysql | column_stats | 0 | mysql | PRIMARY | 2 | table_name | A | NULL | NULL | NULL | BTREE | ||||
def | mysql | gtid_slave_pos | 0 | mysql | PRIMARY | 2 | sub_id | A | 0 | NULL | NULL | BTREE | ||||
def | sprotest | quotations | 0 | sprotest | PRIMARY | 1 | id | A | 0 | NULL | NULL | BTREE | ||||
def | mysql | index_stats | 0 | mysql | PRIMARY | 4 | prefix_arity | A | 0 | NULL | NULL | BTREE | ||||
def | sprotest | transfers | 0 | sprotest | PRIMARY | 1 | id | A | 309 | NULL | NULL | BTREE | ||||
def | mysql | procs_priv | 0 | mysql | PRIMARY | 2 | Db | A | NULL | NULL | NULL | BTREE | ||||
def | mysql | db | 0 | mysql | PRIMARY | 1 | Host | A | NULL | NULL | NULL | BTREE | ||||
def | mysql | help_category | 0 | mysql | name | 1 | name | A | 48 | NULL | NULL | BTREE | ||||
def | sprotest | return_purchases | 0 | sprotest | PRIMARY | 1 | id | A | 0 | NULL | NULL | BTREE | ||||
def | mysql | innodb_index_stats | 0 | mysql | PRIMARY | 2 | table_name | A | 319 | NULL | NULL | BTREE | ||||
def | sprotest | users | 0 | sprotest | PRIMARY | 1 | id | A | 21 | NULL | NULL | BTREE | ||||
def | mysql | procs_priv | 0 | mysql | PRIMARY | 4 | Routine_name | A | NULL | NULL | NULL | BTREE | ||||
def | mysql | db | 0 | mysql | PRIMARY | 3 | User | A | 3 | NULL | NULL | BTREE | ||||
def | mysql | help_keyword | 0 | mysql | name | 1 | name | A | 37 | NULL | NULL | BTREE | ||||
def | sprotest | roles | 0 | sprotest | PRIMARY | 1 | id | A | 5 | NULL | NULL | BTREE | ||||
def | mysql | innodb_index_stats | 0 | mysql | PRIMARY | 4 | stat_name | A | 319 | NULL | NULL | BTREE |
Filtrer les lignes: |