Déposer des fichiers ici

Téléversement SQL ( 0 ) x -

Paramètres relatifs à la page Cliquer sur la barre pour faire défiler en haut de page
Faire Ctrl+Entrée pour exécuter la requête Faire Entrée pour exécuter la requête
croissant
décroissant
Ordre :
Déboguer SQL
Nombre
Ordre d'exécution
Temps nécessaire
Trier par :
Regrouper les requêtes
Dissocier les groupes
Réduire Développer Afficher le suivi Masquer le suivi Nombre : Temps nécessaire :
Signets
Actualiser
Ajouter
Aucun signet
Ajouter un signet
Options
Définir par défaut





Réduire Développer Exécuter la requête à nouveau Éditer Expliquer Profilage Signet La requête a échoué Base de données : Daté du :
Mode de navigation
Personnaliser le mode affichage.
Mode de navigation
Documentation Afficher seulement des icônes, seulement du texte ou les deux. Restaurer la valeur par défaut
Documentation Afficher seulement des icônes, seulement du texte ou les deux. Restaurer la valeur par défaut
Documentation Si un bouton « Tout afficher » devrait être affiché. Restaurer la valeur par défaut
Documentation Nombre de colonnes affichées lors du parcours d'un ensemble de résultats. Si le nombre de colonnes est supérieur, des liens « Suivant » et « Précédent » seront affichés. Restaurer la valeur par défaut
Documentation SMART signifie un ordre décroissant pour les colonnes TIME, DATE, DATETIME et TIMESTAMP, et croissant pour les autres. Restaurer la valeur par défaut
Documentation Mettre en surbrillance la ligne sur laquelle pointe la souris. Restaurer la valeur par défaut
Documentation Mettre en surbrillance les lignes sélectionnées. Restaurer la valeur par défaut
Documentation Restaurer la valeur par défaut
Documentation Restaurer la valeur par défaut
Documentation Répète les entêtes toutes les X cellules, 0 désactive ceci. Restaurer la valeur par défaut
Documentation Nombre maximum de caractères affichés dans toute colonne non numérique en vue parcourir. Restaurer la valeur par défaut
Documentation Il s'agit des liens Éditer, Copier et Supprimer. Restaurer la valeur par défaut
Documentation Pour afficher les liens de la ligne même en l'absence d'une clé unique. Restaurer la valeur par défaut
Documentation Ordre de tri par défaut pour les tables comportant une clé primaire. Restaurer la valeur par défaut
Documentation En affichant les tables, l'ordre de tri de chaque table est mémorisé. Restaurer la valeur par défaut
Documentation Pour les options d'affichage Restaurer la valeur par défaut
SELECT * FROM `TABLE_CONSTRAINTS`
CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_SCHEMA TABLE_NAME CONSTRAINT_TYPE ENFORCED
def mysql PRIMARY mysql innodb_table_stats PRIMARY KEY YES
def mysql PRIMARY mysql innodb_index_stats PRIMARY KEY YES
def performance_schema PRIMARY performance_schema cond_instances PRIMARY KEY YES
def performance_schema PRIMARY performance_schema error_log PRIMARY KEY YES
def performance_schema PRIMARY performance_schema events_waits_current PRIMARY KEY YES
def performance_schema PRIMARY performance_schema events_waits_history PRIMARY KEY YES
def performance_schema HOST performance_schema events_waits_summary_by_host_by_event_name UNIQUE YES
def performance_schema PRIMARY performance_schema events_waits_summary_by_instance PRIMARY KEY YES
def performance_schema PRIMARY performance_schema events_waits_summary_by_thread_by_event_name PRIMARY KEY YES
def performance_schema USER performance_schema events_waits_summary_by_user_by_event_name UNIQUE YES
def performance_schema ACCOUNT performance_schema events_waits_summary_by_account_by_event_name UNIQUE YES
def performance_schema PRIMARY performance_schema events_waits_summary_global_by_event_name PRIMARY KEY YES
def performance_schema PRIMARY performance_schema file_instances PRIMARY KEY YES
def performance_schema PRIMARY performance_schema file_summary_by_event_name PRIMARY KEY YES
def performance_schema PRIMARY performance_schema file_summary_by_instance PRIMARY KEY YES
def performance_schema PRIMARY performance_schema host_cache PRIMARY KEY YES
def performance_schema PRIMARY performance_schema mutex_instances PRIMARY KEY YES
def performance_schema OBJECT performance_schema objects_summary_global_by_type UNIQUE YES
def performance_schema PRIMARY performance_schema processlist PRIMARY KEY YES
def performance_schema PRIMARY performance_schema rwlock_instances PRIMARY KEY YES
def performance_schema PRIMARY performance_schema setup_actors PRIMARY KEY YES
def performance_schema PRIMARY performance_schema setup_consumers PRIMARY KEY YES
def performance_schema PRIMARY performance_schema setup_instruments PRIMARY KEY YES
def performance_schema PRIMARY performance_schema setup_meters PRIMARY KEY YES
def performance_schema PRIMARY performance_schema setup_metrics PRIMARY KEY YES
def performance_schema OBJECT performance_schema setup_objects UNIQUE YES
def performance_schema PRIMARY performance_schema setup_threads PRIMARY KEY YES
def performance_schema OBJECT performance_schema table_io_waits_summary_by_index_usage UNIQUE YES
def performance_schema OBJECT performance_schema table_io_waits_summary_by_table UNIQUE YES
def performance_schema OBJECT performance_schema table_lock_waits_summary_by_table UNIQUE YES
def performance_schema PRIMARY performance_schema threads PRIMARY KEY YES
def performance_schema PRIMARY performance_schema events_stages_current PRIMARY KEY YES
def performance_schema PRIMARY performance_schema events_stages_history PRIMARY KEY YES
def performance_schema PRIMARY performance_schema events_stages_summary_by_thread_by_event_name PRIMARY KEY YES
def performance_schema ACCOUNT performance_schema events_stages_summary_by_account_by_event_name UNIQUE YES
def performance_schema USER performance_schema events_stages_summary_by_user_by_event_name UNIQUE YES
def performance_schema HOST performance_schema events_stages_summary_by_host_by_event_name UNIQUE YES
def performance_schema PRIMARY performance_schema events_stages_summary_global_by_event_name PRIMARY KEY YES
def performance_schema PRIMARY performance_schema events_statements_current PRIMARY KEY YES
def performance_schema PRIMARY performance_schema events_statements_history PRIMARY KEY YES
def performance_schema PRIMARY performance_schema events_statements_summary_by_thread_by_event_name PRIMARY KEY YES
def performance_schema ACCOUNT performance_schema events_statements_summary_by_account_by_event_name UNIQUE YES
def performance_schema USER performance_schema events_statements_summary_by_user_by_event_name UNIQUE YES
def performance_schema HOST performance_schema events_statements_summary_by_host_by_event_name UNIQUE YES
def performance_schema PRIMARY performance_schema events_statements_summary_global_by_event_name PRIMARY KEY YES
def performance_schema SCHEMA_NAME performance_schema events_statements_summary_by_digest UNIQUE YES
def performance_schema PRIMARY performance_schema events_statements_summary_by_program PRIMARY KEY YES
def performance_schema PRIMARY performance_schema events_statements_histogram_global PRIMARY KEY YES
def performance_schema SCHEMA_NAME performance_schema events_statements_histogram_by_digest UNIQUE YES
def performance_schema PRIMARY performance_schema events_transactions_current PRIMARY KEY YES
def performance_schema PRIMARY performance_schema events_transactions_history PRIMARY KEY YES
def performance_schema PRIMARY performance_schema events_transactions_summary_by_thread_by_event_name PRIMARY KEY YES
def performance_schema ACCOUNT performance_schema events_transactions_summary_by_account_by_event_name UNIQUE YES
def performance_schema USER performance_schema events_transactions_summary_by_user_by_event_name UNIQUE YES
def performance_schema HOST performance_schema events_transactions_summary_by_host_by_event_name UNIQUE YES
def performance_schema PRIMARY performance_schema events_transactions_summary_global_by_event_name PRIMARY KEY YES
def performance_schema USER performance_schema events_errors_summary_by_user_by_error UNIQUE YES
def performance_schema HOST performance_schema events_errors_summary_by_host_by_error UNIQUE YES
def performance_schema ACCOUNT performance_schema events_errors_summary_by_account_by_error UNIQUE YES
def performance_schema THREAD_ID performance_schema events_errors_summary_by_thread_by_error UNIQUE YES
def performance_schema ERROR_NUMBER performance_schema events_errors_summary_global_by_error UNIQUE YES
def performance_schema USER performance_schema users UNIQUE YES
def performance_schema ACCOUNT performance_schema accounts UNIQUE YES
def performance_schema HOST performance_schema hosts UNIQUE YES
def performance_schema PRIMARY performance_schema socket_instances PRIMARY KEY YES
def performance_schema PRIMARY performance_schema socket_summary_by_instance PRIMARY KEY YES
def performance_schema PRIMARY performance_schema socket_summary_by_event_name PRIMARY KEY YES
def performance_schema PRIMARY performance_schema session_connect_attrs PRIMARY KEY YES
def performance_schema PRIMARY performance_schema session_account_connect_attrs PRIMARY KEY YES
def performance_schema PRIMARY performance_schema memory_summary_global_by_event_name PRIMARY KEY YES
def performance_schema ACCOUNT performance_schema memory_summary_by_account_by_event_name UNIQUE YES
def performance_schema HOST performance_schema memory_summary_by_host_by_event_name UNIQUE YES
def performance_schema PRIMARY performance_schema memory_summary_by_thread_by_event_name PRIMARY KEY YES
def performance_schema USER performance_schema memory_summary_by_user_by_event_name UNIQUE YES
def performance_schema PRIMARY performance_schema table_handles PRIMARY KEY YES
def performance_schema PRIMARY performance_schema metadata_locks PRIMARY KEY YES
def performance_schema PRIMARY performance_schema data_locks PRIMARY KEY YES
def performance_schema PRIMARY performance_schema replication_connection_configuration PRIMARY KEY YES
def performance_schema PRIMARY performance_schema replication_connection_status PRIMARY KEY YES
def performance_schema PRIMARY performance_schema replication_applier_configuration PRIMARY KEY YES
def performance_schema PRIMARY performance_schema replication_applier_status PRIMARY KEY YES
def performance_schema PRIMARY performance_schema replication_applier_status_by_coordinator PRIMARY KEY YES
def performance_schema PRIMARY performance_schema replication_applier_status_by_worker PRIMARY KEY YES
def performance_schema OWNER_THREAD_ID performance_schema prepared_statements_instances UNIQUE YES
def performance_schema PRIMARY performance_schema prepared_statements_instances PRIMARY KEY YES
def performance_schema PRIMARY performance_schema user_variables_by_thread PRIMARY KEY YES
def performance_schema ACCOUNT performance_schema status_by_account UNIQUE YES
def performance_schema HOST performance_schema status_by_host UNIQUE YES
def performance_schema PRIMARY performance_schema status_by_thread PRIMARY KEY YES
def performance_schema USER performance_schema status_by_user UNIQUE YES
def performance_schema PRIMARY performance_schema global_status PRIMARY KEY YES
def performance_schema PRIMARY performance_schema session_status PRIMARY KEY YES
def performance_schema PRIMARY performance_schema variables_by_thread PRIMARY KEY YES
def performance_schema PRIMARY performance_schema global_variables PRIMARY KEY YES
def performance_schema PRIMARY performance_schema session_variables PRIMARY KEY YES
def performance_schema PRIMARY performance_schema persisted_variables PRIMARY KEY YES
def performance_schema PRIMARY performance_schema user_defined_functions PRIMARY KEY YES
def mysql PRIMARY mysql db PRIMARY KEY YES
def mysql PRIMARY mysql user PRIMARY KEY YES
def mysql PRIMARY mysql default_roles PRIMARY KEY YES
CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_SCHEMA TABLE_NAME CONSTRAINT_TYPE ENFORCED  
def mysql PRIMARY mysql role_edges PRIMARY KEY YES
def mysql PRIMARY mysql global_grants PRIMARY KEY YES
def mysql PRIMARY mysql password_history PRIMARY KEY YES
def mysql PRIMARY mysql func PRIMARY KEY YES
def mysql PRIMARY mysql plugin PRIMARY KEY YES
def mysql name mysql help_topic UNIQUE YES
def mysql PRIMARY mysql help_topic PRIMARY KEY YES
def mysql name mysql help_category UNIQUE YES
def mysql PRIMARY mysql help_category PRIMARY KEY YES
def mysql PRIMARY mysql help_relation PRIMARY KEY YES
def mysql PRIMARY mysql servers PRIMARY KEY YES
def mysql PRIMARY mysql tables_priv PRIMARY KEY YES
def mysql PRIMARY mysql columns_priv PRIMARY KEY YES
def mysql name mysql help_keyword UNIQUE YES
def mysql PRIMARY mysql help_keyword PRIMARY KEY YES
def mysql PRIMARY mysql time_zone_name PRIMARY KEY YES
def mysql PRIMARY mysql time_zone PRIMARY KEY YES
def mysql PRIMARY mysql time_zone_transition PRIMARY KEY YES
def mysql PRIMARY mysql time_zone_transition_type PRIMARY KEY YES
def mysql PRIMARY mysql time_zone_leap_second PRIMARY KEY YES
def mysql PRIMARY mysql procs_priv PRIMARY KEY YES
def mysql PRIMARY mysql component PRIMARY KEY YES
def mysql PRIMARY mysql slave_relay_log_info PRIMARY KEY YES
def mysql PRIMARY mysql slave_master_info PRIMARY KEY YES
def mysql PRIMARY mysql slave_worker_info PRIMARY KEY YES
def mysql PRIMARY mysql gtid_executed PRIMARY KEY YES
def mysql PRIMARY mysql replication_asynchronous_connection_failover PRIMARY KEY YES
def mysql PRIMARY mysql replication_asynchronous_connection_failover_managed PRIMARY KEY YES
def mysql PRIMARY mysql replication_group_member_actions PRIMARY KEY YES
def mysql PRIMARY mysql replication_group_configuration_version PRIMARY KEY YES
def mysql PRIMARY mysql server_cost PRIMARY KEY YES
def mysql PRIMARY mysql engine_cost PRIMARY KEY YES
def mysql PRIMARY mysql proxies_priv PRIMARY KEY YES
def mysql PRIMARY mysql ndb_binlog_index PRIMARY KEY YES
def sys PRIMARY sys sys_config PRIMARY KEY YES
def phpmyadmin PRIMARY phpmyadmin pma__bookmark PRIMARY KEY YES
def phpmyadmin db_name phpmyadmin pma__column_info UNIQUE YES
def phpmyadmin PRIMARY phpmyadmin pma__column_info PRIMARY KEY YES
def phpmyadmin PRIMARY phpmyadmin pma__history PRIMARY KEY YES
def phpmyadmin PRIMARY phpmyadmin pma__pdf_pages PRIMARY KEY YES
def phpmyadmin PRIMARY phpmyadmin pma__recent PRIMARY KEY YES
def phpmyadmin PRIMARY phpmyadmin pma__favorite PRIMARY KEY YES
def phpmyadmin PRIMARY phpmyadmin pma__table_uiprefs PRIMARY KEY YES
def phpmyadmin PRIMARY phpmyadmin pma__relation PRIMARY KEY YES
def phpmyadmin PRIMARY phpmyadmin pma__table_coords PRIMARY KEY YES
def phpmyadmin PRIMARY phpmyadmin pma__table_info PRIMARY KEY YES
def phpmyadmin PRIMARY phpmyadmin pma__tracking PRIMARY KEY YES
def phpmyadmin PRIMARY phpmyadmin pma__userconfig PRIMARY KEY YES
def phpmyadmin PRIMARY phpmyadmin pma__users PRIMARY KEY YES
def phpmyadmin PRIMARY phpmyadmin pma__usergroups PRIMARY KEY YES
def phpmyadmin PRIMARY phpmyadmin pma__navigationhiding PRIMARY KEY YES
def phpmyadmin PRIMARY phpmyadmin pma__savedsearches PRIMARY KEY YES
def phpmyadmin u_savedsearches_username_dbname phpmyadmin pma__savedsearches UNIQUE YES
def phpmyadmin PRIMARY phpmyadmin pma__central_columns PRIMARY KEY YES
def phpmyadmin PRIMARY phpmyadmin pma__designer_settings PRIMARY KEY YES
def phpmyadmin PRIMARY phpmyadmin pma__export_templates PRIMARY KEY YES
def phpmyadmin u_user_type_template phpmyadmin pma__export_templates UNIQUE YES
def webtrees PRIMARY webtrees wt_block PRIMARY KEY YES
def webtrees wt_block_gedcom_id_foreign webtrees wt_block FOREIGN KEY YES
def webtrees wt_block_module_name_foreign webtrees wt_block FOREIGN KEY YES
def webtrees wt_block_user_id_foreign webtrees wt_block FOREIGN KEY YES
def webtrees PRIMARY webtrees wt_block_setting PRIMARY KEY YES
def webtrees wt_block_setting_block_id_foreign webtrees wt_block_setting FOREIGN KEY YES
def webtrees PRIMARY webtrees wt_change PRIMARY KEY YES
def webtrees wt_change_gedcom_id_foreign webtrees wt_change FOREIGN KEY YES
def webtrees wt_change_user_id_foreign webtrees wt_change FOREIGN KEY YES
def webtrees PRIMARY webtrees wt_default_resn PRIMARY KEY YES
def webtrees wt_default_resn_gedcom_id_xref_tag_type_unique webtrees wt_default_resn UNIQUE YES
def webtrees wt_default_resn_gedcom_id_foreign webtrees wt_default_resn FOREIGN KEY YES
def webtrees PRIMARY webtrees wt_families PRIMARY KEY YES
def webtrees wt_families_f_file_f_id_unique webtrees wt_families UNIQUE YES
def webtrees PRIMARY webtrees wt_favorite PRIMARY KEY YES
def webtrees wt_favorite_gedcom_id_foreign webtrees wt_favorite FOREIGN KEY YES
def webtrees wt_favorite_user_id_foreign webtrees wt_favorite FOREIGN KEY YES
def webtrees PRIMARY webtrees wt_gedcom PRIMARY KEY YES
def webtrees wt_gedcom_gedcom_name_unique webtrees wt_gedcom UNIQUE YES
def webtrees PRIMARY webtrees wt_gedcom_chunk PRIMARY KEY YES
def webtrees wt_gedcom_chunk_gedcom_id_foreign webtrees wt_gedcom_chunk FOREIGN KEY YES
def webtrees PRIMARY webtrees wt_gedcom_setting PRIMARY KEY YES
def webtrees wt_gedcom_setting_gedcom_id_foreign webtrees wt_gedcom_setting FOREIGN KEY YES
def webtrees PRIMARY webtrees wt_hit_counter PRIMARY KEY YES
def webtrees wt_hit_counter_gedcom_id_foreign webtrees wt_hit_counter FOREIGN KEY YES
def webtrees PRIMARY webtrees wt_individuals PRIMARY KEY YES
def webtrees wt_individuals_i_file_i_id_unique webtrees wt_individuals UNIQUE YES
def webtrees PRIMARY webtrees wt_link PRIMARY KEY YES
def webtrees wt_link_l_to_l_file_l_type_l_from_unique webtrees wt_link UNIQUE YES
def webtrees PRIMARY webtrees wt_log PRIMARY KEY YES
def webtrees wt_log_gedcom_id_foreign webtrees wt_log FOREIGN KEY YES
def webtrees wt_log_user_id_foreign webtrees wt_log FOREIGN KEY YES
def webtrees PRIMARY webtrees wt_media PRIMARY KEY YES
def webtrees wt_media_m_id_m_file_unique webtrees wt_media UNIQUE YES
def webtrees PRIMARY webtrees wt_media_file PRIMARY KEY YES
def webtrees PRIMARY webtrees wt_message PRIMARY KEY YES
def webtrees wt_message_user_id_foreign webtrees wt_message FOREIGN KEY YES
def webtrees PRIMARY webtrees wt_module PRIMARY KEY YES
def webtrees PRIMARY webtrees wt_module_privacy PRIMARY KEY YES
def webtrees wt_module_privacy_ix1 webtrees wt_module_privacy UNIQUE YES
def webtrees wt_module_privacy_ix2 webtrees wt_module_privacy UNIQUE YES
def webtrees wt_module_privacy_gedcom_id_foreign webtrees wt_module_privacy FOREIGN KEY YES
def webtrees wt_module_privacy_module_name_foreign webtrees wt_module_privacy FOREIGN KEY YES
CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_SCHEMA TABLE_NAME CONSTRAINT_TYPE ENFORCED  
def webtrees PRIMARY webtrees wt_module_setting PRIMARY KEY YES
def webtrees wt_module_setting_module_name_foreign webtrees wt_module_setting FOREIGN KEY YES
def webtrees PRIMARY webtrees wt_name PRIMARY KEY YES
def webtrees PRIMARY webtrees wt_news PRIMARY KEY YES
def webtrees wt_news_gedcom_id_foreign webtrees wt_news FOREIGN KEY YES
def webtrees wt_news_user_id_foreign webtrees wt_news FOREIGN KEY YES
def webtrees PRIMARY webtrees wt_other PRIMARY KEY YES
def webtrees wt_other_o_file_o_id_unique webtrees wt_other UNIQUE YES
def webtrees PRIMARY webtrees wt_place_location PRIMARY KEY YES
def webtrees wt_place_location_parent_id_place_unique webtrees wt_place_location UNIQUE YES
def webtrees wt_place_location_place_parent_id_unique webtrees wt_place_location UNIQUE YES
def webtrees wt_place_location_parent_id_foreign webtrees wt_place_location FOREIGN KEY YES
def webtrees PRIMARY webtrees wt_placelinks PRIMARY KEY YES
def webtrees PRIMARY webtrees wt_places PRIMARY KEY YES
def webtrees wt_places_p_parent_id_p_file_p_place_unique webtrees wt_places UNIQUE YES
def webtrees PRIMARY webtrees wt_session PRIMARY KEY YES
def webtrees PRIMARY webtrees wt_site_setting PRIMARY KEY YES
def webtrees PRIMARY webtrees wt_sources PRIMARY KEY YES
def webtrees wt_sources_s_file_s_id_unique webtrees wt_sources UNIQUE YES
def webtrees PRIMARY webtrees wt_user PRIMARY KEY YES
def webtrees wt_user_email_unique webtrees wt_user UNIQUE YES
def webtrees wt_user_user_name_unique webtrees wt_user UNIQUE YES
def webtrees PRIMARY webtrees wt_user_gedcom_setting PRIMARY KEY YES
def webtrees wt_user_gedcom_setting_gedcom_id_foreign webtrees wt_user_gedcom_setting FOREIGN KEY YES
def webtrees wt_user_gedcom_setting_user_id_foreign webtrees wt_user_gedcom_setting FOREIGN KEY YES
def webtrees PRIMARY webtrees wt_user_setting PRIMARY KEY YES
def webtrees wt_user_setting_user_id_foreign webtrees wt_user_setting FOREIGN KEY YES
Opérations sur les résultats de la requête Copier dans le presse-papiers Copier dans le presse-papiers Exporter Exporter Afficher le graphique Afficher le graphique Créer une vue Créer une vue
Conserver cette requête SQL dans les signets Conserver cette requête SQL dans les signets