SELECT * FROM `STATISTICS`
ORDER BY `STATISTICS`.`INDEX_TYPE` ASC
过滤行: |
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 1 | COMMENT | INDEX_COMMENT | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
def | gym | mbw_store_bill | 0 | gym | PRIMARY | 1 | id | A | 0 | NULL | NULL | BTREE | ||||
def | gym | gym_other_account | 1 | gym | platform_type | 1 | platform_type | A | 5 | NULL | NULL | BTREE | ||||
def | gym | mbw_coach_ad_publish_history | 0 | gym | PRIMARY | 1 | id | A | 0 | NULL | NULL | BTREE | ||||
def | gym | mbw_store_comment_circle_zan | 0 | gym | PRIMARY | 1 | id | A | 2 | NULL | NULL | BTREE | ||||
def | gym | gym_questionnaire_answer | 1 | gym | NewTable_id_IDX | 2 | health_id | A | NULL | NULL | NULL | BTREE | ||||
def | gym | mbw_coach_tzs_fans | 0 | gym | PRIMARY | 1 | id | A | 1 | NULL | NULL | BTREE | ||||
def | gym | superhero_get_cash_setting | 0 | gym | PRIMARY | 1 | id | A | 1 | NULL | NULL | BTREE | ||||
def | gym | mbw_store_dalibao | 0 | gym | PRIMARY | 1 | id | A | 1 | NULL | NULL | BTREE | ||||
def | gym | gym_score_exchange_goods_package | 0 | gym | PRIMARY | 1 | id | A | 4 | NULL | NULL | BTREE | ||||
def | phpmyadmin | pma__savedsearches | 0 | phpmyadmin | PRIMARY | 1 | id | A | 0 | NULL | NULL | BTREE | ||||
def | gym | mbw_sports_coach_video | 0 | gym | PRIMARY | 1 | id | A | 5 | NULL | NULL | BTREE | ||||
def | gym | mbw_yuyue_history | 0 | gym | PRIMARY | 1 | id | A | 0 | NULL | NULL | BTREE | ||||
def | gym | gym_sign_gym | 1 | gym | gym_sign_gym_fitness_instructor_id_IDX | 3 | status | A | 34 | NULL | NULL | BTREE | ||||
def | gym | mbw_csf_pay_on_off | 0 | gym | PRIMARY | 1 | id | A | 1 | NULL | NULL | BTREE | ||||
def | gym | mbw_store_bill | 1 | gym | purchased_price | 1 | purchased_price | A | 0 | NULL | NULL | BTREE | ||||
def | gym | gym_points_log | 0 | gym | PRIMARY | 1 | id | A | 218 | NULL | NULL | BTREE | ||||
def | gym | mbw_coach_tzs | 0 | gym | PRIMARY | 1 | id | A | 1 | NULL | NULL | BTREE | ||||
def | gym | mbw_zhaopin_gallery | 0 | gym | PRIMARY | 1 | id | A | 2 | NULL | NULL | BTREE | ||||
def | gym | mbw_store_comment_score | 0 | gym | PRIMARY | 1 | id | A | 11 | NULL | NULL | BTREE | ||||
def | gym | gym_reservation_course | 1 | gym | gym_reservation_course_id_IDX | 1 | id | A | 0 | NULL | NULL | BTREE | ||||
def | gym | mbw_coach_tzs_share_history | 0 | gym | PRIMARY | 1 | id | A | 1 | NULL | NULL | BTREE | ||||
def | phpmyadmin | pma__column_info | 0 | phpmyadmin | PRIMARY | 1 | id | A | 0 | NULL | NULL | BTREE | ||||
def | gym | mbw_store_data_cache | 0 | gym | PRIMARY | 1 | id | A | 5 | NULL | NULL | BTREE | ||||
def | gym | gym_see_activity | 1 | gym | gym_see_activiry_activity_id_IDX | 1 | activity_id | A | 2 | NULL | NULL | BTREE | ||||
def | gym | mbw_course_union_course | 0 | gym | PRIMARY | 1 | id | A | 12 | NULL | NULL | BTREE |
过滤行: |