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 :
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_EXTENSIONS`
[ Éditer en ligne ] [ Éditer ] [ Expliquer SQL ] [ Créer le code source PHP ] [ Actualiser ]
|
|
|
|
Filtrer les lignes:
CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_NAME ENGINE_ATTRIBUTE SECONDARY_ENGINE_ATTRIBUTE
def mysql PRIMARY innodb_table_stats NULL NULL
def mysql PRIMARY innodb_index_stats NULL NULL
def performance_schema PRIMARY cond_instances NULL NULL
def performance_schema NAME cond_instances NULL NULL
def performance_schema PRIMARY error_log NULL NULL
def performance_schema THREAD_ID error_log NULL NULL
def performance_schema PRIO error_log NULL NULL
def performance_schema ERROR_CODE error_log NULL NULL
def performance_schema SUBSYSTEM error_log NULL NULL
def performance_schema PRIMARY events_waits_current NULL NULL
def performance_schema PRIMARY events_waits_history NULL NULL
def performance_schema HOST events_waits_summary_by_host_by_event_name NULL NULL
def performance_schema PRIMARY events_waits_summary_by_instance NULL NULL
def performance_schema EVENT_NAME events_waits_summary_by_instance NULL NULL
def performance_schema PRIMARY events_waits_summary_by_thread_by_event_name NULL NULL
def performance_schema USER events_waits_summary_by_user_by_event_name NULL NULL
def performance_schema ACCOUNT events_waits_summary_by_account_by_event_name NULL NULL
def performance_schema PRIMARY events_waits_summary_global_by_event_name NULL NULL
def performance_schema PRIMARY file_instances NULL NULL
def performance_schema EVENT_NAME file_instances NULL NULL
def performance_schema PRIMARY file_summary_by_event_name NULL NULL
def performance_schema PRIMARY file_summary_by_instance NULL NULL
def performance_schema FILE_NAME file_summary_by_instance NULL NULL
def performance_schema EVENT_NAME file_summary_by_instance NULL NULL
def performance_schema PRIMARY host_cache NULL NULL
def performance_schema HOST host_cache NULL NULL
def performance_schema PRIMARY mutex_instances NULL NULL
def performance_schema NAME mutex_instances NULL NULL
def performance_schema LOCKED_BY_THREAD_ID mutex_instances NULL NULL
def performance_schema OBJECT objects_summary_global_by_type NULL NULL
def performance_schema PRIMARY processlist NULL NULL
def performance_schema PRIMARY rwlock_instances NULL NULL
def performance_schema NAME rwlock_instances NULL NULL
def performance_schema WRITE_LOCKED_BY_THREAD_ID rwlock_instances NULL NULL
def performance_schema PRIMARY setup_actors NULL NULL
def performance_schema PRIMARY setup_consumers NULL NULL
def performance_schema PRIMARY setup_instruments NULL NULL
def performance_schema PRIMARY setup_meters NULL NULL
def performance_schema PRIMARY setup_metrics NULL NULL
def performance_schema OBJECT setup_objects NULL NULL
def performance_schema PRIMARY setup_threads NULL NULL
def performance_schema OBJECT table_io_waits_summary_by_index_usage NULL NULL
def performance_schema OBJECT table_io_waits_summary_by_table NULL NULL
def performance_schema OBJECT table_lock_waits_summary_by_table NULL NULL
def performance_schema PRIMARY threads NULL NULL
def performance_schema PROCESSLIST_ID threads NULL NULL
def performance_schema THREAD_OS_ID threads NULL NULL
def performance_schema NAME threads NULL NULL
def performance_schema PROCESSLIST_ACCOUNT threads NULL NULL
def performance_schema PROCESSLIST_HOST threads NULL NULL
def performance_schema RESOURCE_GROUP threads NULL NULL
def performance_schema PRIMARY events_stages_current NULL NULL
def performance_schema PRIMARY events_stages_history NULL NULL
def performance_schema PRIMARY events_stages_summary_by_thread_by_event_name NULL NULL
def performance_schema ACCOUNT events_stages_summary_by_account_by_event_name NULL NULL
def performance_schema USER events_stages_summary_by_user_by_event_name NULL NULL
def performance_schema HOST events_stages_summary_by_host_by_event_name NULL NULL
def performance_schema PRIMARY events_stages_summary_global_by_event_name NULL NULL
def performance_schema PRIMARY events_statements_current NULL NULL
def performance_schema PRIMARY events_statements_history NULL NULL
def performance_schema PRIMARY events_statements_summary_by_thread_by_event_name NULL NULL
def performance_schema ACCOUNT events_statements_summary_by_account_by_event_name NULL NULL
def performance_schema USER events_statements_summary_by_user_by_event_name NULL NULL
def performance_schema HOST events_statements_summary_by_host_by_event_name NULL NULL
def performance_schema PRIMARY events_statements_summary_global_by_event_name NULL NULL
def performance_schema SCHEMA_NAME events_statements_summary_by_digest NULL NULL
def performance_schema PRIMARY events_statements_summary_by_program NULL NULL
def performance_schema PRIMARY events_statements_histogram_global NULL NULL
def performance_schema SCHEMA_NAME events_statements_histogram_by_digest NULL NULL
def performance_schema PRIMARY events_transactions_current NULL NULL
def performance_schema PRIMARY events_transactions_history NULL NULL
def performance_schema PRIMARY events_transactions_summary_by_thread_by_event_nam... NULL NULL
def performance_schema ACCOUNT events_transactions_summary_by_account_by_event_na... NULL NULL
def performance_schema USER events_transactions_summary_by_user_by_event_name NULL NULL
def performance_schema HOST events_transactions_summary_by_host_by_event_name NULL NULL
def performance_schema PRIMARY events_transactions_summary_global_by_event_name NULL NULL
def performance_schema USER events_errors_summary_by_user_by_error NULL NULL
def performance_schema HOST events_errors_summary_by_host_by_error NULL NULL
def performance_schema ACCOUNT events_errors_summary_by_account_by_error NULL NULL
def performance_schema THREAD_ID events_errors_summary_by_thread_by_error NULL NULL
def performance_schema ERROR_NUMBER events_errors_summary_global_by_error NULL NULL
def performance_schema USER users NULL NULL
def performance_schema ACCOUNT accounts NULL NULL
def performance_schema HOST hosts NULL NULL
def performance_schema PRIMARY socket_instances NULL NULL
def performance_schema THREAD_ID socket_instances NULL NULL
def performance_schema SOCKET_ID socket_instances NULL NULL
def performance_schema IP socket_instances NULL NULL
def performance_schema PRIMARY socket_summary_by_instance NULL NULL
def performance_schema EVENT_NAME socket_summary_by_instance NULL NULL
def performance_schema PRIMARY socket_summary_by_event_name NULL NULL
def performance_schema PRIMARY session_connect_attrs NULL NULL
def performance_schema PRIMARY session_account_connect_attrs NULL NULL
def performance_schema PRIMARY memory_summary_global_by_event_name NULL NULL
def performance_schema ACCOUNT memory_summary_by_account_by_event_name NULL NULL
def performance_schema HOST memory_summary_by_host_by_event_name NULL NULL
def performance_schema PRIMARY memory_summary_by_thread_by_event_name NULL NULL
def performance_schema USER memory_summary_by_user_by_event_name NULL NULL
def performance_schema PRIMARY table_handles NULL NULL
def performance_schema OBJECT_TYPE table_handles NULL NULL
CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_NAME ENGINE_ATTRIBUTE SECONDARY_ENGINE_ATTRIBUTE  
def performance_schema OWNER_THREAD_ID table_handles NULL NULL
def performance_schema PRIMARY metadata_locks NULL NULL
def performance_schema OBJECT_TYPE metadata_locks NULL NULL
def performance_schema OWNER_THREAD_ID metadata_locks NULL NULL
def performance_schema PRIMARY data_locks NULL NULL
def performance_schema ENGINE_TRANSACTION_ID data_locks NULL NULL
def performance_schema THREAD_ID data_locks NULL NULL
def performance_schema OBJECT_SCHEMA data_locks NULL NULL
def performance_schema REQUESTING_ENGINE_LOCK_ID data_lock_waits NULL NULL
def performance_schema BLOCKING_ENGINE_LOCK_ID data_lock_waits NULL NULL
def performance_schema REQUESTING_ENGINE_TRANSACTION_ID data_lock_waits NULL NULL
def performance_schema BLOCKING_ENGINE_TRANSACTION_ID data_lock_waits NULL NULL
def performance_schema REQUESTING_THREAD_ID data_lock_waits NULL NULL
def performance_schema BLOCKING_THREAD_ID data_lock_waits NULL NULL
def performance_schema PRIMARY replication_connection_configuration NULL NULL
def performance_schema PRIMARY replication_connection_status NULL NULL
def performance_schema THREAD_ID replication_connection_status NULL NULL
def performance_schema PRIMARY replication_applier_configuration NULL NULL
def performance_schema PRIMARY replication_applier_status NULL NULL
def performance_schema PRIMARY replication_applier_status_by_coordinator NULL NULL
def performance_schema THREAD_ID replication_applier_status_by_coordinator NULL NULL
def performance_schema PRIMARY replication_applier_status_by_worker NULL NULL
def performance_schema THREAD_ID replication_applier_status_by_worker NULL NULL
def performance_schema PRIMARY prepared_statements_instances NULL NULL
def performance_schema OWNER_THREAD_ID prepared_statements_instances NULL NULL
def performance_schema STATEMENT_ID prepared_statements_instances NULL NULL
def performance_schema STATEMENT_NAME prepared_statements_instances NULL NULL
def performance_schema OWNER_OBJECT_TYPE prepared_statements_instances NULL NULL
def performance_schema PRIMARY user_variables_by_thread NULL NULL
def performance_schema ACCOUNT status_by_account NULL NULL
def performance_schema HOST status_by_host NULL NULL
def performance_schema PRIMARY status_by_thread NULL NULL
def performance_schema USER status_by_user NULL NULL
def performance_schema PRIMARY global_status NULL NULL
def performance_schema PRIMARY session_status NULL NULL
def performance_schema PRIMARY variables_by_thread NULL NULL
def performance_schema PRIMARY global_variables NULL NULL
def performance_schema PRIMARY session_variables NULL NULL
def performance_schema PRIMARY persisted_variables NULL NULL
def performance_schema PRIMARY user_defined_functions NULL NULL
def mysql PRIMARY db NULL NULL
def mysql User db NULL NULL
def mysql PRIMARY user NULL NULL
def mysql PRIMARY default_roles NULL NULL
def mysql PRIMARY role_edges NULL NULL
def mysql PRIMARY global_grants NULL NULL
def mysql PRIMARY password_history NULL NULL
def mysql PRIMARY func NULL NULL
def mysql PRIMARY plugin NULL NULL
def mysql PRIMARY help_topic NULL NULL
def mysql name help_topic NULL NULL
def mysql PRIMARY help_category NULL NULL
def mysql name help_category NULL NULL
def mysql PRIMARY help_relation NULL NULL
def mysql PRIMARY servers NULL NULL
def mysql PRIMARY tables_priv NULL NULL
def mysql Grantor tables_priv NULL NULL
def mysql PRIMARY columns_priv NULL NULL
def mysql PRIMARY help_keyword NULL NULL
def mysql name help_keyword NULL NULL
def mysql PRIMARY time_zone_name NULL NULL
def mysql PRIMARY time_zone NULL NULL
def mysql PRIMARY time_zone_transition NULL NULL
def mysql PRIMARY time_zone_transition_type NULL NULL
def mysql PRIMARY time_zone_leap_second NULL NULL
def mysql PRIMARY procs_priv NULL NULL
def mysql Grantor procs_priv NULL NULL
def mysql PRIMARY component NULL NULL
def mysql PRIMARY slave_relay_log_info NULL NULL
def mysql PRIMARY slave_master_info NULL NULL
def mysql PRIMARY slave_worker_info NULL NULL
def mysql PRIMARY gtid_executed NULL NULL
def mysql PRIMARY replication_asynchronous_connection_failover NULL NULL
def mysql Channel_name replication_asynchronous_connection_failover NULL NULL
def mysql PRIMARY replication_asynchronous_connection_failover_manag... NULL NULL
def mysql PRIMARY replication_group_member_actions NULL NULL
def mysql event replication_group_member_actions NULL NULL
def mysql PRIMARY replication_group_configuration_version NULL NULL
def mysql PRIMARY server_cost NULL NULL
def mysql PRIMARY engine_cost NULL NULL
def mysql PRIMARY proxies_priv NULL NULL
def mysql Grantor proxies_priv NULL NULL
def mysql PRIMARY ndb_binlog_index NULL NULL
def sys PRIMARY sys_config NULL NULL
def phpmyadmin PRIMARY pma__bookmark NULL NULL
def phpmyadmin PRIMARY pma__column_info NULL NULL
def phpmyadmin db_name pma__column_info NULL NULL
def phpmyadmin PRIMARY pma__history NULL NULL
def phpmyadmin username pma__history NULL NULL
def phpmyadmin PRIMARY pma__pdf_pages NULL NULL
def phpmyadmin db_name pma__pdf_pages NULL NULL
def phpmyadmin PRIMARY pma__recent NULL NULL
def phpmyadmin PRIMARY pma__favorite NULL NULL
def phpmyadmin PRIMARY pma__table_uiprefs NULL NULL
def phpmyadmin PRIMARY pma__relation NULL NULL
def phpmyadmin foreign_field pma__relation NULL NULL
def phpmyadmin PRIMARY pma__table_coords NULL NULL
def phpmyadmin PRIMARY pma__table_info NULL NULL
def phpmyadmin PRIMARY pma__tracking NULL NULL
def phpmyadmin PRIMARY pma__userconfig NULL NULL
CONSTRAINT_CATALOG CONSTRAINT_SCHEMA CONSTRAINT_NAME TABLE_NAME ENGINE_ATTRIBUTE SECONDARY_ENGINE_ATTRIBUTE  
def phpmyadmin PRIMARY pma__users NULL NULL
def phpmyadmin PRIMARY pma__usergroups NULL NULL
def phpmyadmin PRIMARY pma__navigationhiding NULL NULL
def phpmyadmin PRIMARY pma__savedsearches NULL NULL
def phpmyadmin u_savedsearches_username_dbname pma__savedsearches NULL NULL
def phpmyadmin PRIMARY pma__central_columns NULL NULL
def phpmyadmin PRIMARY pma__designer_settings NULL NULL
def phpmyadmin PRIMARY pma__export_templates NULL NULL
def phpmyadmin u_user_type_template pma__export_templates NULL NULL
def webtrees PRIMARY wt_block NULL NULL
def webtrees wt_block_module_name_index wt_block NULL NULL
def webtrees wt_block_gedcom_id_index wt_block NULL NULL
def webtrees wt_block_user_id_index wt_block NULL NULL
def webtrees PRIMARY wt_block_setting NULL NULL
def webtrees PRIMARY wt_change NULL NULL
def webtrees wt_change_gedcom_id_status_xref_index wt_change NULL NULL
def webtrees wt_change_user_id_index wt_change NULL NULL
def webtrees PRIMARY wt_dates NULL NULL
def webtrees wt_dates_d_day_index wt_dates NULL NULL
def webtrees wt_dates_d_month_index wt_dates NULL NULL
def webtrees wt_dates_d_mon_index wt_dates NULL NULL
def webtrees wt_dates_d_year_index wt_dates NULL NULL
def webtrees wt_dates_d_julianday1_index wt_dates NULL NULL
def webtrees wt_dates_d_julianday2_index wt_dates NULL NULL
def webtrees wt_dates_d_gid_index wt_dates NULL NULL
def webtrees wt_dates_d_file_index wt_dates NULL NULL
def webtrees wt_dates_d_type_index wt_dates NULL NULL
def webtrees wt_dates_d_fact_d_gid_index wt_dates NULL NULL
def webtrees PRIMARY wt_default_resn NULL NULL
def webtrees wt_default_resn_gedcom_id_xref_tag_type_unique wt_default_resn NULL NULL
def webtrees PRIMARY wt_families NULL NULL
def webtrees wt_families_f_file_f_id_unique wt_families NULL NULL
def webtrees wt_families_f_husb_index wt_families NULL NULL
def webtrees wt_families_f_wife_index wt_families NULL NULL
def webtrees PRIMARY wt_favorite NULL NULL
def webtrees wt_favorite_user_id_index wt_favorite NULL NULL
def webtrees wt_favorite_gedcom_id_user_id_index wt_favorite NULL NULL
def webtrees PRIMARY wt_gedcom NULL NULL
def webtrees wt_gedcom_gedcom_name_unique wt_gedcom NULL NULL
def webtrees wt_gedcom_sort_order_index wt_gedcom NULL NULL
def webtrees PRIMARY wt_gedcom_chunk NULL NULL
def webtrees wt_gedcom_chunk_gedcom_id_imported_index wt_gedcom_chunk NULL NULL
def webtrees PRIMARY wt_gedcom_setting NULL NULL
def webtrees PRIMARY wt_hit_counter NULL NULL
def webtrees PRIMARY wt_individuals NULL NULL
def webtrees wt_individuals_i_file_i_id_unique wt_individuals NULL NULL
def webtrees PRIMARY wt_link NULL NULL
def webtrees wt_link_l_to_l_file_l_type_l_from_unique wt_link NULL NULL
def webtrees PRIMARY wt_log NULL NULL
def webtrees wt_log_log_time_index wt_log NULL NULL
def webtrees wt_log_log_type_index wt_log NULL NULL
def webtrees wt_log_ip_address_index wt_log NULL NULL
def webtrees wt_log_user_id_index wt_log NULL NULL
def webtrees wt_log_gedcom_id_index wt_log NULL NULL
def webtrees PRIMARY wt_media NULL NULL
def webtrees wt_media_m_id_m_file_unique wt_media NULL NULL
def webtrees PRIMARY wt_media_file NULL NULL
def webtrees wt_media_file_m_id_m_file_index wt_media_file NULL NULL
def webtrees wt_media_file_m_file_m_id_index wt_media_file NULL NULL
def webtrees wt_media_file_m_file_multimedia_file_refn_index wt_media_file NULL NULL
def webtrees wt_media_file_m_file_multimedia_format_index wt_media_file NULL NULL
def webtrees wt_media_file_m_file_source_media_type_index wt_media_file NULL NULL
def webtrees wt_media_file_m_file_descriptive_title_index wt_media_file NULL NULL
def webtrees PRIMARY wt_message NULL NULL
def webtrees wt_message_user_id_index wt_message NULL NULL
def webtrees PRIMARY wt_module NULL NULL
def webtrees PRIMARY wt_module_privacy NULL NULL
def webtrees wt_module_privacy_ix1 wt_module_privacy NULL NULL
def webtrees wt_module_privacy_ix2 wt_module_privacy NULL NULL
def webtrees PRIMARY wt_module_setting NULL NULL
def webtrees PRIMARY wt_name NULL NULL
def webtrees wt_name_n_full_n_id_n_file_index wt_name NULL NULL
def webtrees wt_name_n_surn_n_file_n_type_n_id_index wt_name NULL NULL
def webtrees wt_name_n_givn_n_file_n_type_n_id_index wt_name NULL NULL
def webtrees PRIMARY wt_news NULL NULL
def webtrees wt_news_user_id_updated_index wt_news NULL NULL
def webtrees wt_news_gedcom_id_updated_index wt_news NULL NULL
def webtrees PRIMARY wt_other NULL NULL
def webtrees wt_other_o_file_o_id_unique wt_other NULL NULL
def webtrees PRIMARY wt_place_location NULL NULL
def webtrees wt_place_location_parent_id_place_unique wt_place_location NULL NULL
def webtrees wt_place_location_place_parent_id_unique wt_place_location NULL NULL
def webtrees wt_place_location_latitude_index wt_place_location NULL NULL
def webtrees wt_place_location_longitude_index wt_place_location NULL NULL
def webtrees PRIMARY wt_placelinks NULL NULL
def webtrees wt_placelinks_pl_p_id_index wt_placelinks NULL NULL
def webtrees wt_placelinks_pl_gid_index wt_placelinks NULL NULL
def webtrees wt_placelinks_pl_file_index wt_placelinks NULL NULL
def webtrees PRIMARY wt_places NULL NULL
def webtrees wt_places_p_parent_id_p_file_p_place_unique wt_places NULL NULL
def webtrees wt_places_p_file_p_place_index wt_places NULL NULL
def webtrees PRIMARY wt_session NULL NULL
def webtrees wt_session_session_time_index wt_session NULL NULL
def webtrees wt_session_user_id_ip_address_index wt_session NULL NULL
def webtrees PRIMARY wt_site_setting NULL NULL
def webtrees PRIMARY wt_sources NULL NULL
def webtrees wt_sources_s_file_s_id_unique wt_sources NULL NULL
def webtrees wt_sources_s_name_index wt_sources NULL NULL
def webtrees PRIMARY wt_user NULL NULL
def webtrees wt_user_user_name_unique wt_user NULL NULL
|
|
|
|
Filtrer les lignes:
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