La sélection courante ne contient pas de colonne unique. Les grilles d'édition, les cases à cocher ainsi que les liens Éditer, Copier et Supprimer ne sont pas disponibles.
Affichage des lignes 0 - ...
Cette vue contient au moins ce nombre de lignes. Merci de se référer à documentation. (traitement en 0,0960 seconde(s).) [TABLE_SCHEMA: MYSQL... - MYSQL...]
SELECT * FROM `KEY_COLUMN_USAGE` ORDER BY `TABLE_SCHEMA` ASC
| Filtrer les lignes: |
| CONSTRAINT_CATALOG | CONSTRAINT_SCHEMA | CONSTRAINT_NAME | TABLE_CATALOG | TABLE_SCHEMA 1
| TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | POSITION_IN_UNIQUE_CONSTRAINT | REFERENCED_TABLE_SCHEMA | REFERENCED_TABLE_NAME | REFERENCED_COLUMN_NAME | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| def | mysql | PRIMARY | def | mysql | gtid_slave_pos | domain_id | 1 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | innodb_index_stats | index_name | 3 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | proxies_priv | Proxied_user | 4 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | time_zone_transition | Time_zone_id | 1 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | db | Host | 1 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | help_topic | help_topic_id | 1 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | procs_priv | Host | 1 | NULL | NULL | NULL | NULL | |
| 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 | gtid_slave_pos | sub_id | 2 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | innodb_index_stats | stat_name | 4 | NULL | NULL | NULL | NULL | |
| def | mysql | Host | def | mysql | roles_mapping | Host | 1 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | time_zone_transition | Transition_time | 2 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | db | Db | 2 | NULL | NULL | NULL | NULL | |
| def | mysql | name | def | mysql | help_topic | name | 1 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | procs_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 | help_category | help_category_id | 1 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | innodb_table_stats | database_name | 1 | NULL | NULL | NULL | NULL | |
| def | mysql | Host | def | mysql | roles_mapping | User | 2 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | time_zone_transition_type | Time_zone_id | 1 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | db | User | 3 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | index_stats | db_name | 1 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | procs_priv | User | 3 | NULL | NULL | NULL | NULL | |
| def | mysql | PRIMARY | def | mysql | tables_priv | Table_name | 4 | NULL | NULL | NULL | NULL |
| Filtrer les lignes: |