Rilascia i file qui

Upload SQL ( 0 ) x -

Impostazioni specifiche della pagina Clicca sulla barra per scorrere fino all'inizio della pagina
Premere Ctrl+Enter per eseguire la query Premere INVIO per eseguire query
crescente
decrescente
Ordine:
Debug SQL
Conteggio
Ordine di esecuzione
Tempo utilizzato
Ordine per:
Raggruppa query
Dividi Query
Riduci Espandi Mostra traccia Nascondi traccia Conteggio: Tempo utilizzato:
Bookmark
Aggiorna
Aggiungi
Nessun segnalibro
Aggiungi segnalibro
Opzioni
Imposta i valori predefiniti
Riduci Espandi Re-query Modifica Spiega Profiling Segnalibro Query fallita Database: Tempo in coda:
Modalitá di navigazione
Personalizza modalità di navigazione.
Modalitá di navigazione
Documentazione Usa solo icone, solo testo o entrambi. Ripristinare valori predefiniti
Documentazione Usa solo icone, solo testo o entrambi. Ripristinare valori predefiniti
Documentazione Se visualizzare all'utente un pulsante "mostra tutte le (righe)". Ripristinare valori predefiniti
Documentazione Il numero di righe visualizzato durante la navigazione dei risulati. Se i risultati contengono ulteriori righe i collegamenti "Precedente" e "Seguente" saranno mostrati. Ripristinare valori predefiniti
Documentazione SMART - ad esempio ordine decrescente per i campi di tipo TIME, DATE, DATETIME e TIMESTAMP, ordine crescente altrimenti. Ripristinare valori predefiniti
Documentazione Evidenzia le righe al passaggio del mouse. Ripristinare valori predefiniti
Documentazione Evidenzia le righe selezionate. Ripristinare valori predefiniti
Documentazione Ripristinare valori predefiniti
Documentazione Ripristinare valori predefiniti
Documentazione Ripeti le intestazioni ogni X celle, 0 disattiva questa funzionalità. Ripristinare valori predefiniti
Documentazione Il numero massimo di caratteri mostrati in qualsiasi campo non-numerico nella vista di navigazione. Ripristinare valori predefiniti
Documentazione Questi sono i collegamenti per Modifica, Copia ed Elimina. Ripristinare valori predefiniti
Documentazione Se visualizzare i link di riga anche in assenza di una chiave univoca. Ripristinare valori predefiniti
Documentazione Criterio di ordinamento predefinito per le tabelle con chiave primaria. Ripristinare valori predefiniti
Documentazione L'ordine delle tabelle é memorizzato durante la navigazione delle tabelle. Ripristinare valori predefiniti
Documentazione Per le Opzioni di visualizzazione Ripristinare valori predefiniti
SELECT * FROM `innodb_index_stats`
Modifica inline ] [ Modifica ] [ Spiega SQL ] [ Crea il codice PHP ] [ Aggiorna ]
Testi completi database_name table_name index_name last_update stat_name stat_value sample_size stat_description
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'OO_employe' AND `innodb_index_stats`.`table_name` = 'employe' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
OO_employe employe PRIMARY 2022-09-28 16:09:25 n_diff_pfx01 20 1 idEmploye
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'OO_employe' AND `innodb_index_stats`.`table_name` = 'employe' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
OO_employe employe PRIMARY 2022-09-28 16:09:25 n_leaf_pages 1 NULL Number of leaf pages in the index
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'OO_employe' AND `innodb_index_stats`.`table_name` = 'employe' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
OO_employe employe PRIMARY 2022-09-28 16:09:25 size 1 NULL Number of pages in the index
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'alas_al_aire' AND `innodb_index_stats`.`table_name` = '#mysql50##sql-388_5b14' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
alas_al_aire #mysql50##sql-388_5b14 PRIMARY 2022-09-28 23:33:28 n_diff_pfx01 2 1 id
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'alas_al_aire' AND `innodb_index_stats`.`table_name` = '#mysql50##sql-388_5b14' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
alas_al_aire #mysql50##sql-388_5b14 PRIMARY 2022-09-28 23:33:28 n_leaf_pages 1 NULL Number of leaf pages in the index
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'alas_al_aire' AND `innodb_index_stats`.`table_name` = '#mysql50##sql-388_5b14' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
alas_al_aire #mysql50##sql-388_5b14 PRIMARY 2022-09-28 23:33:28 size 1 NULL Number of pages in the index
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'alas_al_aire' AND `innodb_index_stats`.`table_name` = '#mysql50##sql-388_5b14' AND `innodb_index_stats`.`index_name` = 'fk_idSalon' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
alas_al_aire #mysql50##sql-388_5b14 fk_idSalon 2022-09-28 23:33:28 n_diff_pfx01 1 1 idSalon
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'alas_al_aire' AND `innodb_index_stats`.`table_name` = '#mysql50##sql-388_5b14' AND `innodb_index_stats`.`index_name` = 'fk_idSalon' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx02'
alas_al_aire #mysql50##sql-388_5b14 fk_idSalon 2022-09-28 23:33:28 n_diff_pfx02 2 1 idSalon,id
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'alas_al_aire' AND `innodb_index_stats`.`table_name` = '#mysql50##sql-388_5b14' AND `innodb_index_stats`.`index_name` = 'fk_idSalon' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
alas_al_aire #mysql50##sql-388_5b14 fk_idSalon 2022-09-28 23:33:28 n_leaf_pages 1 NULL Number of leaf pages in the index
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'alas_al_aire' AND `innodb_index_stats`.`table_name` = '#mysql50##sql-388_5b14' AND `innodb_index_stats`.`index_name` = 'fk_idSalon' AND `innodb_index_stats`.`stat_name` = 'size'
alas_al_aire #mysql50##sql-388_5b14 fk_idSalon 2022-09-28 23:33:28 size 1 NULL Number of pages in the index
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'alas_al_aire' AND `innodb_index_stats`.`table_name` = 'APARATO' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
alas_al_aire APARATO PRIMARY 2022-09-28 19:46:50 n_diff_pfx01 0 1 Modelo
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'alas_al_aire' AND `innodb_index_stats`.`table_name` = 'APARATO' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
alas_al_aire APARATO PRIMARY 2022-09-28 19:46:50 n_leaf_pages 1 NULL Number of leaf pages in the index
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'alas_al_aire' AND `innodb_index_stats`.`table_name` = 'APARATO' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
alas_al_aire APARATO PRIMARY 2022-09-28 19:46:50 size 1 NULL Number of pages in the index
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'alas_al_aire' AND `innodb_index_stats`.`table_name` = 'AVION' AND `innodb_index_stats`.`index_name` = 'Modelo' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
alas_al_aire AVION Modelo 2022-09-28 19:46:50 n_diff_pfx01 0 1 Modelo
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'alas_al_aire' AND `innodb_index_stats`.`table_name` = 'AVION' AND `innodb_index_stats`.`index_name` = 'Modelo' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx02'
alas_al_aire AVION Modelo 2022-09-28 19:46:50 n_diff_pfx02 0 1 Modelo,Matricula
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'alas_al_aire' AND `innodb_index_stats`.`table_name` = 'AVION' AND `innodb_index_stats`.`index_name` = 'Modelo' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
alas_al_aire AVION Modelo 2022-09-28 19:46:50 n_leaf_pages 1 NULL Number of leaf pages in the index
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'alas_al_aire' AND `innodb_index_stats`.`table_name` = 'AVION' AND `innodb_index_stats`.`index_name` = 'Modelo' AND `innodb_index_stats`.`stat_name` = 'size'
alas_al_aire AVION Modelo 2022-09-28 19:46:50 size 1 NULL Number of pages in the index
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'alas_al_aire' AND `innodb_index_stats`.`table_name` = 'AVION' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
alas_al_aire AVION PRIMARY 2022-09-28 19:46:50 n_diff_pfx01 0 1 Matricula
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'alas_al_aire' AND `innodb_index_stats`.`table_name` = 'AVION' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
alas_al_aire AVION PRIMARY 2022-09-28 19:46:50 n_leaf_pages 1 NULL Number of leaf pages in the index
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'alas_al_aire' AND `innodb_index_stats`.`table_name` = 'AVION' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
alas_al_aire AVION PRIMARY 2022-09-28 19:46:50 size 1 NULL Number of pages in the index
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'alas_al_aire' AND `innodb_index_stats`.`table_name` = 'EMPLEADO' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
alas_al_aire EMPLEADO PRIMARY 2022-09-28 19:46:50 n_diff_pfx01 0 1 NumEmpleado
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'alas_al_aire' AND `innodb_index_stats`.`table_name` = 'EMPLEADO' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
alas_al_aire EMPLEADO PRIMARY 2022-09-28 19:46:50 n_leaf_pages 1 NULL Number of leaf pages in the index
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'alas_al_aire' AND `innodb_index_stats`.`table_name` = 'EMPLEADO' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
alas_al_aire EMPLEADO PRIMARY 2022-09-28 19:46:50 size 1 NULL Number of pages in the index
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'alas_al_aire' AND `innodb_index_stats`.`table_name` = 'PASAJERO' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
alas_al_aire PASAJERO PRIMARY 2022-09-28 19:46:50 n_diff_pfx01 0 1 Nombre
Modifica Modifica Copia Copia Elimina Elimina
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'alas_al_aire' AND `innodb_index_stats`.`table_name` = 'PASAJERO' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx02'
alas_al_aire PASAJERO PRIMARY 2022-09-28 19:46:50 n_diff_pfx02 0 1 Nombre,Direccion
Se selezionati: Se selezionati:
Operazioni sui risultati della query
Aggiungi ai preferiti questa query SQL Aggiungi ai preferiti questa query SQL