Solte os arquivos aqui

Envio de SQL ( 0 ) x -

Configurações da página Clique na barra para rolar até o topo da página
Pressione Ctrl+Enter para executar consulta Pressione Enter para executar consulta
ascendente
descendente
Ordem:
Depurar SQL
Contagem
Ordem de execução
Tempo gasto
Ordenar por:
Agrupar consultas
Desagrupar consultas
Recolher Expandir Mostrar rastro Ocultar rastro Count: Tempo gasto:
Favoritos
Atualizar
Adicionar
Sem marcador(es)
Adicionar marcador
Opções
Definir padrão
Recolher Expandir Repetir consulta Editar Demonstrar SQL Perfil Marcadores Falha na consulta Banco de dados: Tempo de execução da consulta:
Modo de navegação
Personalizar modo de navegação.
Modo de navegação
Documentação Usar apenas ícones, apenas texto ou ambos. Restaurar valor padrão
Documentação Usar apenas ícones, apenas texto ou ambos. Restaurar valor padrão
Documentação Se exibe ao usuário o botão "exibir tudo(linhas)". Restaurar valor padrão
Documentação Número de linhas exibidas na visualização do resultado encontrado. Se o resultado conter mais linhas, os links 'Anterior' e 'Próximo' serão apresentados. Restaurar valor padrão
Documentação SMART - i.e. ordem decrescente para colunas do tipo TIME, DATE, DATETIME e TIMESTAMP, caso contrário, ordem ascendente. Restaurar valor padrão
Documentação Destacar linha apontada pelo cursor do mouse. Restaurar valor padrão
Documentação Destacar linhas selecionadas. Restaurar valor padrão
Documentação Restaurar valor padrão
Documentação Restaurar valor padrão
Documentação Repetir cabeçalhos a cada X células, 0 desativa esta funcionalidade. Restaurar valor padrão
Documentação Número máximo de caracteres apresentados em qualquer coluna não-numérica em modo de navegação. Restaurar valor padrão
Documentação Estes são os links de Editar, Copiar e Apagar. Restaurar valor padrão
Documentação Se os links de linha devem ser mostrados mesmo na ausência de chave única. Restaurar valor padrão
Documentação Ordenação predeterminada para tabelas com uma chave primária. Restaurar valor padrão
Documentação Quando navegar por tabelas, a organização de cada tabela será lembrada. Restaurar valor padrão
Documentação Para exibir as Opções Restaurar valor padrão
SELECT * FROM `innodb_index_stats`
Editar em linha ] [ Editar ] [ Demonstrar SQL ] [ Criar código PHP ] [ Atualizar ]
Textos completos database_name table_name index_name last_update stat_name stat_value sample_size stat_description
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'EsquemaProgramas344072' AND `innodb_index_stats`.`table_name` = 'Cliente' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
EsquemaProgramas344072 Cliente PRIMARY 2022-08-20 07:33:02 n_diff_pfx01 0 1 id_Cliente
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'EsquemaProgramas344072' AND `innodb_index_stats`.`table_name` = 'Cliente' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
EsquemaProgramas344072 Cliente PRIMARY 2022-08-20 07:33:02 n_leaf_pages 1 NULL Number of leaf pages in the index
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'EsquemaProgramas344072' AND `innodb_index_stats`.`table_name` = 'Cliente' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
EsquemaProgramas344072 Cliente PRIMARY 2022-08-20 07:33:02 size 1 NULL Number of pages in the index
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'EsquemaProgramas344072' AND `innodb_index_stats`.`table_name` = 'Direccion' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
EsquemaProgramas344072 Direccion PRIMARY 2022-08-20 07:33:02 n_diff_pfx01 0 1 id_Direccion
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'EsquemaProgramas344072' AND `innodb_index_stats`.`table_name` = 'Direccion' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
EsquemaProgramas344072 Direccion PRIMARY 2022-08-20 07:33:02 n_leaf_pages 1 NULL Number of leaf pages in the index
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'EsquemaProgramas344072' AND `innodb_index_stats`.`table_name` = 'Direccion' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
EsquemaProgramas344072 Direccion PRIMARY 2022-08-20 07:33:02 size 1 NULL Number of pages in the index
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'EsquemaProgramas344072' AND `innodb_index_stats`.`table_name` = 'categoria' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
EsquemaProgramas344072 categoria PRIMARY 2022-08-20 07:33:02 n_diff_pfx01 0 1 id_Categoria
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'EsquemaProgramas344072' AND `innodb_index_stats`.`table_name` = 'categoria' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
EsquemaProgramas344072 categoria PRIMARY 2022-08-20 07:33:02 n_leaf_pages 1 NULL Number of leaf pages in the index
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'EsquemaProgramas344072' AND `innodb_index_stats`.`table_name` = 'categoria' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
EsquemaProgramas344072 categoria PRIMARY 2022-08-20 07:33:02 size 1 NULL Number of pages in the index
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'menagerie' AND `innodb_index_stats`.`table_name` = 'event' AND `innodb_index_stats`.`index_name` = 'GEN_CLUST_INDEX' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
menagerie event GEN_CLUST_INDEX 2013-12-18 15:04:57 n_diff_pfx01 10 1 DB_ROW_ID
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'menagerie' AND `innodb_index_stats`.`table_name` = 'event' AND `innodb_index_stats`.`index_name` = 'GEN_CLUST_INDEX' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
menagerie event GEN_CLUST_INDEX 2013-12-18 15:04:57 n_leaf_pages 1 NULL Number of leaf pages in the index
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'menagerie' AND `innodb_index_stats`.`table_name` = 'event' AND `innodb_index_stats`.`index_name` = 'GEN_CLUST_INDEX' AND `innodb_index_stats`.`stat_name` = 'size'
menagerie event GEN_CLUST_INDEX 2013-12-18 15:04:57 size 1 NULL Number of pages in the index
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'menagerie' AND `innodb_index_stats`.`table_name` = 'pet' AND `innodb_index_stats`.`index_name` = 'GEN_CLUST_INDEX' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
menagerie pet GEN_CLUST_INDEX 2013-12-18 15:05:07 n_diff_pfx01 9 1 DB_ROW_ID
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'menagerie' AND `innodb_index_stats`.`table_name` = 'pet' AND `innodb_index_stats`.`index_name` = 'GEN_CLUST_INDEX' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
menagerie pet GEN_CLUST_INDEX 2013-12-18 15:05:07 n_leaf_pages 1 NULL Number of leaf pages in the index
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'menagerie' AND `innodb_index_stats`.`table_name` = 'pet' AND `innodb_index_stats`.`index_name` = 'GEN_CLUST_INDEX' AND `innodb_index_stats`.`stat_name` = 'size'
menagerie pet GEN_CLUST_INDEX 2013-12-18 15:05:07 size 1 NULL Number of pages in the index
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'mysql' AND `innodb_index_stats`.`table_name` = 'gtid_slave_pos' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
mysql gtid_slave_pos PRIMARY 2013-12-18 14:25:38 n_diff_pfx01 0 1 domain_id
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'mysql' AND `innodb_index_stats`.`table_name` = 'gtid_slave_pos' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx02'
mysql gtid_slave_pos PRIMARY 2013-12-18 14:25:38 n_diff_pfx02 0 1 domain_id,sub_id
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'mysql' AND `innodb_index_stats`.`table_name` = 'gtid_slave_pos' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
mysql gtid_slave_pos PRIMARY 2013-12-18 14:25:38 n_leaf_pages 1 NULL Number of leaf pages in the index
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'mysql' AND `innodb_index_stats`.`table_name` = 'gtid_slave_pos' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
mysql gtid_slave_pos PRIMARY 2013-12-18 14:25:38 size 1 NULL Number of pages in the index
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'phpmyadmin' AND `innodb_index_stats`.`table_name` = 'pma__bookmark' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
phpmyadmin pma__bookmark PRIMARY 2017-03-09 14:34:31 n_diff_pfx01 0 1 id
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'phpmyadmin' AND `innodb_index_stats`.`table_name` = 'pma__bookmark' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
phpmyadmin pma__bookmark PRIMARY 2017-03-09 14:34:31 n_leaf_pages 1 NULL Number of leaf pages in the index
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'phpmyadmin' AND `innodb_index_stats`.`table_name` = 'pma__bookmark' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
phpmyadmin pma__bookmark PRIMARY 2017-03-09 14:34:31 size 1 NULL Number of pages in the index
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'phpmyadmin' AND `innodb_index_stats`.`table_name` = 'pma__central_columns' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
phpmyadmin pma__central_columns PRIMARY 2017-03-09 14:34:39 n_diff_pfx01 0 1 db_name
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'phpmyadmin' AND `innodb_index_stats`.`table_name` = 'pma__central_columns' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx02'
phpmyadmin pma__central_columns PRIMARY 2017-03-09 14:34:39 n_diff_pfx02 0 1 db_name,col_name
Editar Editar Copiar Copiar Remover Remover
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'phpmyadmin' AND `innodb_index_stats`.`table_name` = 'pma__central_columns' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
phpmyadmin pma__central_columns PRIMARY 2017-03-09 14:34:39 n_leaf_pages 1 NULL Number of leaf pages in the index
Com marcados: Com marcados:
Operações resultantes das consultas
Marcar essa consulta SQL Marcar essa consulta SQL