SELECT * FROM `STATISTICS`
ORDER BY `STATISTICS`.`CARDINALITY` ASC
过滤行: |
TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | NON_UNIQUE | INDEX_SCHEMA | INDEX_NAME | SEQ_IN_INDEX | COLUMN_NAME | COLLATION | CARDINALITY 1 | SUB_PART | PACKED | NULLABLE | INDEX_TYPE | COMMENT | INDEX_COMMENT | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
def | gym | gym_questionnaire_answer | 1 | gym | NewTable_id_IDX | 1 | id | A | NULL | NULL | NULL | BTREE | ||||
def | gym | gym_show_reviews | 1 | gym | show_reviews_id_IDX | 1 | id | A | NULL | NULL | NULL | BTREE | ||||
def | gym | gym_question_types | 1 | gym | question_types_id_IDX | 1 | id | A | NULL | NULL | NULL | BTREE | ||||
def | gym | gym_nutritious_meal_history | 1 | gym | gym_nutritious_meal_id_IDX | 1 | id | A | NULL | NULL | NULL | BTREE | ||||
def | gym | gym_opinion_feedback | 1 | gym | create_time | 1 | create_time | A | NULL | NULL | NULL | BTREE | ||||
def | gym | gym_hour_course | 1 | gym | gym_hour_course_fitness_id_IDX | 2 | member_id | A | NULL | NULL | NULL | BTREE | ||||
def | gym | gym_notifycation | 1 | gym | type | 1 | type | A | NULL | NULL | NULL | BTREE | ||||
def | gym | gym_gym_photo_album | 1 | gym | gym_photo_album_id_IDX | 1 | id | A | NULL | NULL | NULL | BTREE | ||||
def | gym | gym_circle_comment | 1 | gym | uid | 1 | uid | A | NULL | NULL | NULL | BTREE | ||||
def | gym | gym_certificate_of_merit | 1 | gym | gym_certificate_of_merit_id_IDX | 2 | sender_id | A | NULL | NULL | NULL | BTREE | ||||
def | gym | gym_circle_comment | 1 | gym | uid_2 | 1 | uid | A | NULL | NULL | NULL | BTREE | ||||
def | gym | gym_course_dynamic | 1 | gym | NewTable_id_IDX | 2 | coach_id | A | NULL | NULL | NULL | BTREE | ||||
def | mysql | proc | 0 | mysql | PRIMARY | 2 | name | A | NULL | NULL | NULL | BTREE | ||||
def | gym | gym_certificate_of_merit | 1 | gym | gym_certificate_of_merit_id_IDX | 4 | gym_id | A | NULL | NULL | NULL | BTREE | ||||
def | gym | gym_course_dynamic | 1 | gym | NewTable_id_IDX | 4 | member_id | A | NULL | NULL | NULL | BTREE | ||||
def | mysql | proc | 1 | mysql | character_set_client | 1 | character_set_client | A | NULL | NULL | NULL | YES | BTREE | |||
def | gym | gym_circle | 1 | gym | gym_circle_type_IDX | 1 | type | A | NULL | NULL | NULL | BTREE | ||||
def | gym | gym_course | 1 | gym | gym_course_id_IDX | 2 | create_time | A | NULL | NULL | NULL | BTREE | ||||
def | gym | gym_thumb_up | 1 | gym | gym_thumb_up_id_IDX | 1 | id | A | NULL | NULL | NULL | BTREE | ||||
def | gym | gym_auth_rule | 1 | gym | listorder | 1 | listorder | A | NULL | NULL | NULL | BTREE | ||||
def | gym | gym_circle | 1 | gym | gym_circle_type_IDX | 3 | last_update_time | A | NULL | NULL | NULL | BTREE | ||||
def | gym | gym_circle | 1 | gym | gym_circle_type_IDX | 5 | index_id | A | NULL | NULL | NULL | BTREE | ||||
def | gym | gym_course_content | 1 | gym | gym_course_content_id_IDX | 2 | course_id | A | NULL | NULL | NULL | BTREE | ||||
def | gym | gym_questionnaire_answer | 1 | gym | NewTable_id_IDX | 2 | health_id | A | NULL | NULL | NULL | BTREE | ||||
def | gym | gym_show_reviews | 1 | gym | show_reviews_id_IDX | 2 | circle_id | A | NULL | NULL | NULL | BTREE |
过滤行: |