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 `TABLES_EXTENSIONS`
[ Éditer en ligne ] [ Éditer ] [ Expliquer SQL ] [ Créer le code source PHP ] [ Actualiser ]
|
|
|
|
Filtrer les lignes:
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME ENGINE_ATTRIBUTE SECONDARY_ENGINE_ATTRIBUTE
def information_schema ADMINISTRABLE_ROLE_AUTHORIZATIONS NULL NULL
def information_schema APPLICABLE_ROLES NULL NULL
def information_schema CHARACTER_SETS NULL NULL
def information_schema CHECK_CONSTRAINTS NULL NULL
def information_schema COLLATION_CHARACTER_SET_APPLICABILITY NULL NULL
def information_schema COLLATIONS NULL NULL
def information_schema COLUMN_PRIVILEGES NULL NULL
def information_schema COLUMN_STATISTICS NULL NULL
def information_schema COLUMNS NULL NULL
def information_schema COLUMNS_EXTENSIONS NULL NULL
def information_schema ENABLED_ROLES NULL NULL
def information_schema ENGINES NULL NULL
def information_schema EVENTS NULL NULL
def information_schema FILES NULL NULL
def information_schema INNODB_BUFFER_PAGE NULL NULL
def information_schema INNODB_BUFFER_PAGE_LRU NULL NULL
def information_schema INNODB_BUFFER_POOL_STATS NULL NULL
def information_schema INNODB_CACHED_INDEXES NULL NULL
def information_schema INNODB_CMP NULL NULL
def information_schema INNODB_CMP_PER_INDEX NULL NULL
def information_schema INNODB_CMP_PER_INDEX_RESET NULL NULL
def information_schema INNODB_CMP_RESET NULL NULL
def information_schema INNODB_CMPMEM NULL NULL
def information_schema INNODB_CMPMEM_RESET NULL NULL
def information_schema INNODB_COLUMNS NULL NULL
def information_schema INNODB_DATAFILES NULL NULL
def information_schema INNODB_FIELDS NULL NULL
def information_schema INNODB_FOREIGN NULL NULL
def information_schema INNODB_FOREIGN_COLS NULL NULL
def information_schema INNODB_FT_BEING_DELETED NULL NULL
def information_schema INNODB_FT_CONFIG NULL NULL
def information_schema INNODB_FT_DEFAULT_STOPWORD NULL NULL
def information_schema INNODB_FT_DELETED NULL NULL
def information_schema INNODB_FT_INDEX_CACHE NULL NULL
def information_schema INNODB_FT_INDEX_TABLE NULL NULL
def information_schema INNODB_INDEXES NULL NULL
def information_schema INNODB_METRICS NULL NULL
def information_schema INNODB_SESSION_TEMP_TABLESPACES NULL NULL
def information_schema INNODB_TABLES NULL NULL
def information_schema INNODB_TABLESPACES NULL NULL
def information_schema INNODB_TABLESPACES_BRIEF NULL NULL
def information_schema INNODB_TABLESTATS NULL NULL
def information_schema INNODB_TEMP_TABLE_INFO NULL NULL
def information_schema INNODB_TRX NULL NULL
def information_schema INNODB_VIRTUAL NULL NULL
def information_schema KEY_COLUMN_USAGE NULL NULL
def information_schema KEYWORDS NULL NULL
def information_schema OPTIMIZER_TRACE NULL NULL
def information_schema PARAMETERS NULL NULL
def information_schema PARTITIONS NULL NULL
def information_schema PLUGINS NULL NULL
def information_schema PROCESSLIST NULL NULL
def information_schema PROFILING NULL NULL
def information_schema REFERENTIAL_CONSTRAINTS NULL NULL
def information_schema RESOURCE_GROUPS NULL NULL
def information_schema ROLE_COLUMN_GRANTS NULL NULL
def information_schema ROLE_ROUTINE_GRANTS NULL NULL
def information_schema ROLE_TABLE_GRANTS NULL NULL
def information_schema ROUTINES NULL NULL
def information_schema SCHEMA_PRIVILEGES NULL NULL
def information_schema SCHEMATA NULL NULL
def information_schema SCHEMATA_EXTENSIONS NULL NULL
def information_schema ST_GEOMETRY_COLUMNS NULL NULL
def information_schema ST_SPATIAL_REFERENCE_SYSTEMS NULL NULL
def information_schema ST_UNITS_OF_MEASURE NULL NULL
def information_schema STATISTICS NULL NULL
def information_schema TABLE_CONSTRAINTS NULL NULL
def information_schema TABLE_CONSTRAINTS_EXTENSIONS NULL NULL
def information_schema TABLE_PRIVILEGES NULL NULL
def information_schema TABLES NULL NULL
def information_schema TABLES_EXTENSIONS NULL NULL
def information_schema TABLESPACES NULL NULL
def information_schema TABLESPACES_EXTENSIONS NULL NULL
def information_schema TRIGGERS NULL NULL
def information_schema USER_ATTRIBUTES NULL NULL
def information_schema USER_PRIVILEGES NULL NULL
def information_schema VIEW_ROUTINE_USAGE NULL NULL
def information_schema VIEW_TABLE_USAGE NULL NULL
def information_schema VIEWS NULL NULL
def mysql columns_priv NULL NULL
def mysql component NULL NULL
def mysql db NULL NULL
def mysql default_roles NULL NULL
def mysql engine_cost NULL NULL
def mysql func NULL NULL
def mysql general_log NULL NULL
def mysql global_grants NULL NULL
def mysql gtid_executed NULL NULL
def mysql help_category NULL NULL
def mysql help_keyword NULL NULL
def mysql help_relation NULL NULL
def mysql help_topic NULL NULL
def mysql innodb_index_stats NULL NULL
def mysql innodb_table_stats NULL NULL
def mysql ndb_binlog_index NULL NULL
def mysql password_history NULL NULL
def mysql plugin NULL NULL
def mysql procs_priv NULL NULL
def mysql proxies_priv NULL NULL
def mysql replication_asynchronous_connection_failover NULL NULL
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME ENGINE_ATTRIBUTE SECONDARY_ENGINE_ATTRIBUTE  
def mysql replication_asynchronous_connection_failover_manag... NULL NULL
def mysql replication_group_configuration_version NULL NULL
def mysql replication_group_member_actions NULL NULL
def mysql role_edges NULL NULL
def mysql server_cost NULL NULL
def mysql servers NULL NULL
def mysql slave_master_info NULL NULL
def mysql slave_relay_log_info NULL NULL
def mysql slave_worker_info NULL NULL
def mysql slow_log NULL NULL
def mysql tables_priv NULL NULL
def mysql time_zone NULL NULL
def mysql time_zone_leap_second NULL NULL
def mysql time_zone_name NULL NULL
def mysql time_zone_transition NULL NULL
def mysql time_zone_transition_type NULL NULL
def mysql user NULL NULL
def performance_schema accounts NULL NULL
def performance_schema binary_log_transaction_compression_stats NULL NULL
def performance_schema cond_instances NULL NULL
def performance_schema data_lock_waits NULL NULL
def performance_schema data_locks NULL NULL
def performance_schema error_log NULL NULL
def performance_schema events_errors_summary_by_account_by_error NULL NULL
def performance_schema events_errors_summary_by_host_by_error NULL NULL
def performance_schema events_errors_summary_by_thread_by_error NULL NULL
def performance_schema events_errors_summary_by_user_by_error NULL NULL
def performance_schema events_errors_summary_global_by_error NULL NULL
def performance_schema events_stages_current NULL NULL
def performance_schema events_stages_history NULL NULL
def performance_schema events_stages_history_long NULL NULL
def performance_schema events_stages_summary_by_account_by_event_name NULL NULL
def performance_schema events_stages_summary_by_host_by_event_name NULL NULL
def performance_schema events_stages_summary_by_thread_by_event_name NULL NULL
def performance_schema events_stages_summary_by_user_by_event_name NULL NULL
def performance_schema events_stages_summary_global_by_event_name NULL NULL
def performance_schema events_statements_current NULL NULL
def performance_schema events_statements_histogram_by_digest NULL NULL
def performance_schema events_statements_histogram_global NULL NULL
def performance_schema events_statements_history NULL NULL
def performance_schema events_statements_history_long NULL NULL
def performance_schema events_statements_summary_by_account_by_event_name NULL NULL
def performance_schema events_statements_summary_by_digest NULL NULL
def performance_schema events_statements_summary_by_host_by_event_name NULL NULL
def performance_schema events_statements_summary_by_program NULL NULL
def performance_schema events_statements_summary_by_thread_by_event_name NULL NULL
def performance_schema events_statements_summary_by_user_by_event_name NULL NULL
def performance_schema events_statements_summary_global_by_event_name NULL NULL
def performance_schema events_transactions_current NULL NULL
def performance_schema events_transactions_history NULL NULL
def performance_schema events_transactions_history_long NULL NULL
def performance_schema events_transactions_summary_by_account_by_event_na... NULL NULL
def performance_schema events_transactions_summary_by_host_by_event_name NULL NULL
def performance_schema events_transactions_summary_by_thread_by_event_nam... NULL NULL
def performance_schema events_transactions_summary_by_user_by_event_name NULL NULL
def performance_schema events_transactions_summary_global_by_event_name NULL NULL
def performance_schema events_waits_current NULL NULL
def performance_schema events_waits_history NULL NULL
def performance_schema events_waits_history_long NULL NULL
def performance_schema events_waits_summary_by_account_by_event_name NULL NULL
def performance_schema events_waits_summary_by_host_by_event_name NULL NULL
def performance_schema events_waits_summary_by_instance NULL NULL
def performance_schema events_waits_summary_by_thread_by_event_name NULL NULL
def performance_schema events_waits_summary_by_user_by_event_name NULL NULL
def performance_schema events_waits_summary_global_by_event_name NULL NULL
def performance_schema file_instances NULL NULL
def performance_schema file_summary_by_event_name NULL NULL
def performance_schema file_summary_by_instance NULL NULL
def performance_schema global_status NULL NULL
def performance_schema global_variables NULL NULL
def performance_schema host_cache NULL NULL
def performance_schema hosts NULL NULL
def performance_schema innodb_redo_log_files NULL NULL
def performance_schema keyring_component_status NULL NULL
def performance_schema keyring_keys NULL NULL
def performance_schema log_status NULL NULL
def performance_schema memory_summary_by_account_by_event_name NULL NULL
def performance_schema memory_summary_by_host_by_event_name NULL NULL
def performance_schema memory_summary_by_thread_by_event_name NULL NULL
def performance_schema memory_summary_by_user_by_event_name NULL NULL
def performance_schema memory_summary_global_by_event_name NULL NULL
def performance_schema metadata_locks NULL NULL
def performance_schema mutex_instances NULL NULL
def performance_schema objects_summary_global_by_type NULL NULL
def performance_schema performance_timers NULL NULL
def performance_schema persisted_variables NULL NULL
def performance_schema prepared_statements_instances NULL NULL
def performance_schema processlist NULL NULL
def performance_schema replication_applier_configuration NULL NULL
def performance_schema replication_applier_filters NULL NULL
def performance_schema replication_applier_global_filters NULL NULL
def performance_schema replication_applier_status NULL NULL
def performance_schema replication_applier_status_by_coordinator NULL NULL
def performance_schema replication_applier_status_by_worker NULL NULL
def performance_schema replication_asynchronous_connection_failover NULL NULL
def performance_schema replication_asynchronous_connection_failover_manag... NULL NULL
def performance_schema replication_connection_configuration NULL NULL
def performance_schema replication_connection_status NULL NULL
def performance_schema replication_group_member_stats NULL NULL
def performance_schema replication_group_members NULL NULL
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME ENGINE_ATTRIBUTE SECONDARY_ENGINE_ATTRIBUTE  
def performance_schema rwlock_instances NULL NULL
def performance_schema session_account_connect_attrs NULL NULL
def performance_schema session_connect_attrs NULL NULL
def performance_schema session_status NULL NULL
def performance_schema session_variables NULL NULL
def performance_schema setup_actors NULL NULL
def performance_schema setup_consumers NULL NULL
def performance_schema setup_instruments NULL NULL
def performance_schema setup_meters NULL NULL
def performance_schema setup_metrics NULL NULL
def performance_schema setup_objects NULL NULL
def performance_schema setup_threads NULL NULL
def performance_schema socket_instances NULL NULL
def performance_schema socket_summary_by_event_name NULL NULL
def performance_schema socket_summary_by_instance NULL NULL
def performance_schema status_by_account NULL NULL
def performance_schema status_by_host NULL NULL
def performance_schema status_by_thread NULL NULL
def performance_schema status_by_user NULL NULL
def performance_schema table_handles NULL NULL
def performance_schema table_io_waits_summary_by_index_usage NULL NULL
def performance_schema table_io_waits_summary_by_table NULL NULL
def performance_schema table_lock_waits_summary_by_table NULL NULL
def performance_schema threads NULL NULL
def performance_schema tls_channel_status NULL NULL
def performance_schema user_defined_functions NULL NULL
def performance_schema user_variables_by_thread NULL NULL
def performance_schema users NULL NULL
def performance_schema variables_by_thread NULL NULL
def performance_schema variables_info NULL NULL
def phpmyadmin pma__bookmark NULL NULL
def phpmyadmin pma__central_columns NULL NULL
def phpmyadmin pma__column_info NULL NULL
def phpmyadmin pma__designer_settings NULL NULL
def phpmyadmin pma__export_templates NULL NULL
def phpmyadmin pma__favorite NULL NULL
def phpmyadmin pma__history NULL NULL
def phpmyadmin pma__navigationhiding NULL NULL
def phpmyadmin pma__pdf_pages NULL NULL
def phpmyadmin pma__recent NULL NULL
def phpmyadmin pma__relation NULL NULL
def phpmyadmin pma__savedsearches NULL NULL
def phpmyadmin pma__table_coords NULL NULL
def phpmyadmin pma__table_info NULL NULL
def phpmyadmin pma__table_uiprefs NULL NULL
def phpmyadmin pma__tracking NULL NULL
def phpmyadmin pma__userconfig NULL NULL
def phpmyadmin pma__usergroups NULL NULL
def phpmyadmin pma__users NULL NULL
def sys host_summary NULL NULL
def sys host_summary_by_file_io NULL NULL
def sys host_summary_by_file_io_type NULL NULL
def sys host_summary_by_stages NULL NULL
def sys host_summary_by_statement_latency NULL NULL
def sys host_summary_by_statement_type NULL NULL
def sys innodb_buffer_stats_by_schema NULL NULL
def sys innodb_buffer_stats_by_table NULL NULL
def sys innodb_lock_waits NULL NULL
def sys io_by_thread_by_latency NULL NULL
def sys io_global_by_file_by_bytes NULL NULL
def sys io_global_by_file_by_latency NULL NULL
def sys io_global_by_wait_by_bytes NULL NULL
def sys io_global_by_wait_by_latency NULL NULL
def sys latest_file_io NULL NULL
def sys memory_by_host_by_current_bytes NULL NULL
def sys memory_by_thread_by_current_bytes NULL NULL
def sys memory_by_user_by_current_bytes NULL NULL
def sys memory_global_by_current_bytes NULL NULL
def sys memory_global_total NULL NULL
def sys metrics NULL NULL
def sys processlist NULL NULL
def sys ps_check_lost_instrumentation NULL NULL
def sys schema_auto_increment_columns NULL NULL
def sys schema_index_statistics NULL NULL
def sys schema_object_overview NULL NULL
def sys schema_redundant_indexes NULL NULL
def sys schema_table_lock_waits NULL NULL
def sys schema_table_statistics NULL NULL
def sys schema_table_statistics_with_buffer NULL NULL
def sys schema_tables_with_full_table_scans NULL NULL
def sys schema_unused_indexes NULL NULL
def sys session NULL NULL
def sys session_ssl_status NULL NULL
def sys statement_analysis NULL NULL
def sys statements_with_errors_or_warnings NULL NULL
def sys statements_with_full_table_scans NULL NULL
def sys statements_with_runtimes_in_95th_percentile NULL NULL
def sys statements_with_sorting NULL NULL
def sys statements_with_temp_tables NULL NULL
def sys sys_config NULL NULL
def sys user_summary NULL NULL
def sys user_summary_by_file_io NULL NULL
def sys user_summary_by_file_io_type NULL NULL
def sys user_summary_by_stages NULL NULL
def sys user_summary_by_statement_latency NULL NULL
def sys user_summary_by_statement_type NULL NULL
def sys version NULL NULL
def sys wait_classes_global_by_avg_latency NULL NULL
def sys wait_classes_global_by_latency NULL NULL
def sys waits_by_host_by_latency 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