SELECT * FROM `KEY_COLUMN_USAGE`
ORDER BY `KEY_COLUMN_USAGE`.`TABLE_NAME` ASC
过滤行: |
CONSTRAINT_CATALOG | CONSTRAINT_SCHEMA | CONSTRAINT_NAME | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME 1 | COLUMN_NAME | ORDINAL_POSITION | POSITION_IN_UNIQUE_CONSTRAINT | REFERENCED_TABLE_SCHEMA | REFERENCED_TABLE_NAME | REFERENCED_COLUMN_NAME | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
def | mysql | PRIMARY | def | mysql | columns_priv | Host | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | columns_priv | Db | 2 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | columns_priv | User | 3 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | columns_priv | Table_name | 4 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | columns_priv | Column_name | 5 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | column_stats | db_name | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | column_stats | table_name | 2 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | column_stats | column_name | 3 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | db | Host | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | db | Db | 2 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | db | User | 3 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | func | name | 1 | NULL | NULL | NULL | NULL | |
def | gym | PRIMARY | def | gym | gym_answer_supplement | id | 1 | NULL | NULL | NULL | NULL | |
def | gym | PRIMARY | def | gym | gym_auth_group | id | 1 | NULL | NULL | NULL | NULL | |
def | gym | PRIMARY | def | gym | gym_auth_group_relation | id | 1 | NULL | NULL | NULL | NULL | |
def | gym | controller | def | gym | gym_auth_rule | controller | 1 | NULL | NULL | NULL | NULL | |
def | gym | PRIMARY | def | gym | gym_auth_rule | id | 1 | NULL | NULL | NULL | NULL | |
def | gym | PRIMARY | def | gym | gym_boss_point_rule | id | 1 | NULL | NULL | NULL | NULL | |
def | gym | PRIMARY | def | gym | gym_captcha_code | code_key | 1 | NULL | NULL | NULL | NULL | |
def | gym | PRIMARY | def | gym | gym_certificate_of_merit | id | 1 | NULL | NULL | NULL | NULL | |
def | gym | PRIMARY | def | gym | gym_circle | id | 1 | NULL | NULL | NULL | NULL | |
def | gym | PRIMARY | def | gym | gym_circle_comment | id | 1 | NULL | NULL | NULL | NULL | |
def | gym | PRIMARY | def | gym | gym_coach_card | id | 1 | NULL | NULL | NULL | NULL | |
def | gym | PRIMARY | def | gym | gym_coach_course | id | 1 | NULL | NULL | NULL | NULL | |
def | gym | PRIMARY | def | gym | gym_coach_course_list | id | 1 | NULL | NULL | NULL | NULL |
过滤行: |