SELECT * FROM `KEY_COLUMN_USAGE`
CONSTRAINT_CATALOG | CONSTRAINT_SCHEMA | CONSTRAINT_NAME | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | 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 | 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 | event | db | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | event | name | 2 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | func | name | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | help_category | help_category_id | 1 | NULL | NULL | NULL | NULL | |
def | mysql | name | def | mysql | help_category | name | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | help_keyword | help_keyword_id | 1 | NULL | NULL | NULL | NULL | |
def | mysql | name | def | mysql | help_keyword | name | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | help_relation | help_keyword_id | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | help_relation | help_topic_id | 2 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | help_topic | help_topic_id | 1 | NULL | NULL | NULL | NULL | |
def | mysql | name | def | mysql | help_topic | name | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | innodb_index_stats | database_name | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | innodb_index_stats | table_name | 2 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | innodb_index_stats | index_name | 3 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | innodb_index_stats | stat_name | 4 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | innodb_table_stats | database_name | 1 | NULL | NULL | NULL | NULL | |
def | mysql | PRIMARY | def | mysql | innodb_table_stats | table_name | 2 | NULL | NULL | NULL | NULL |