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 `COLUMNS`
[ Éditer en ligne ] [ Éditer ] [ Expliquer SQL ] [ Créer le code source PHP ] [ Actualiser ]
|
|
|
|
Filtrer les lignes:
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE COLUMN_KEY EXTRA PRIVILEGES COLUMN_COMMENT GENERATION_EXPRESSION SRS_ID
def mysql innodb_table_stats database_name 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) PRI select,insert,update,references NULL
def mysql innodb_table_stats table_name 2 NULL NO varchar 199 597 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(199) PRI select,insert,update,references NULL
def mysql innodb_table_stats last_update 3 CURRENT_TIMESTAMP NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP select,insert,update,references NULL
def mysql innodb_table_stats n_rows 4 NULL NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references NULL
def mysql innodb_table_stats clustered_index_size 5 NULL NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references NULL
def mysql innodb_table_stats sum_of_other_index_sizes 6 NULL NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references NULL
def mysql innodb_index_stats database_name 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) PRI select,insert,update,references NULL
def mysql innodb_index_stats table_name 2 NULL NO varchar 199 597 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(199) PRI select,insert,update,references NULL
def mysql innodb_index_stats index_name 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) PRI select,insert,update,references NULL
def mysql innodb_index_stats last_update 4 CURRENT_TIMESTAMP NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP select,insert,update,references NULL
def mysql innodb_index_stats stat_name 5 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) PRI select,insert,update,references NULL
def mysql innodb_index_stats stat_value 6 NULL NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references NULL
def mysql innodb_index_stats sample_size 7 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select,insert,update,references NULL
def mysql innodb_index_stats stat_description 8 NULL NO varchar 1024 3072 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(1024) select,insert,update,references NULL
def information_schema CHARACTER_SETS CHARACTER_SET_NAME 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema CHARACTER_SETS DEFAULT_COLLATE_NAME 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema CHARACTER_SETS DESCRIPTION 3 NULL NO varchar 2048 6144 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(2048) select NULL
def information_schema CHARACTER_SETS MAXLEN 4 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
def information_schema CHECK_CONSTRAINTS CONSTRAINT_CATALOG 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema CHECK_CONSTRAINTS CONSTRAINT_SCHEMA 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema CHECK_CONSTRAINTS CONSTRAINT_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema CHECK_CONSTRAINTS CHECK_CLAUSE 4 NULL NO longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL
def information_schema COLLATIONS COLLATION_NAME 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema COLLATIONS CHARACTER_SET_NAME 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema COLLATIONS ID 3 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
def information_schema COLLATIONS IS_DEFAULT 4 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
def information_schema COLLATIONS IS_COMPILED 5 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
def information_schema COLLATIONS SORTLEN 6 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
def information_schema COLLATIONS PAD_ATTRIBUTE 7 NULL NO enum 9 27 NULL NULL NULL utf8mb3 utf8mb3_bin enum('PAD SPACE','NO PAD') select NULL
def information_schema COLLATION_CHARACTER_SET_APPLICABILITY COLLATION_NAME 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema COLLATION_CHARACTER_SET_APPLICABILITY CHARACTER_SET_NAME 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema COLUMNS TABLE_CATALOG 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema COLUMNS TABLE_SCHEMA 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema COLUMNS TABLE_NAME 3 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema COLUMNS COLUMN_NAME 4 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema COLUMNS ORDINAL_POSITION 5 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
def information_schema COLUMNS COLUMN_DEFAULT 6 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select NULL
def information_schema COLUMNS IS_NULLABLE 7 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
def information_schema COLUMNS DATA_TYPE 8 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL
def information_schema COLUMNS CHARACTER_MAXIMUM_LENGTH 9 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
def information_schema COLUMNS CHARACTER_OCTET_LENGTH 10 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
def information_schema COLUMNS NUMERIC_PRECISION 11 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
def information_schema COLUMNS NUMERIC_SCALE 12 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
def information_schema COLUMNS DATETIME_PRECISION 13 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
def information_schema COLUMNS CHARACTER_SET_NAME 14 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema COLUMNS COLLATION_NAME 15 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema COLUMNS COLUMN_TYPE 16 NULL NO mediumtext 16777215 16777215 NULL NULL NULL utf8mb3 utf8mb3_bin mediumtext select NULL
def information_schema COLUMNS COLUMN_KEY 17 NULL NO enum 3 9 NULL NULL NULL utf8mb3 utf8mb3_bin enum('','PRI','UNI','MUL') select NULL
def information_schema COLUMNS EXTRA 18 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
def information_schema COLUMNS PRIVILEGES 19 NULL YES varchar 154 462 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(154) select NULL
def information_schema COLUMNS COLUMN_COMMENT 20 NULL NO text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select NULL
def information_schema COLUMNS GENERATION_EXPRESSION 21 NULL NO longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL
def information_schema COLUMNS SRS_ID 22 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
def information_schema COLUMNS_EXTENSIONS TABLE_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema COLUMNS_EXTENSIONS TABLE_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema COLUMNS_EXTENSIONS TABLE_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema COLUMNS_EXTENSIONS COLUMN_NAME 4 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema COLUMNS_EXTENSIONS ENGINE_ATTRIBUTE 5 NULL YES json NULL NULL NULL NULL NULL NULL NULL json select NULL
def information_schema COLUMNS_EXTENSIONS SECONDARY_ENGINE_ATTRIBUTE 6 NULL YES json NULL NULL NULL NULL NULL NULL NULL json select NULL
def information_schema COLUMN_STATISTICS SCHEMA_NAME 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema COLUMN_STATISTICS TABLE_NAME 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema COLUMN_STATISTICS COLUMN_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema COLUMN_STATISTICS HISTOGRAM 4 NULL NO json NULL NULL NULL NULL NULL NULL NULL json select NULL
def information_schema EVENTS EVENT_CATALOG 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema EVENTS EVENT_SCHEMA 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema EVENTS EVENT_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema EVENTS DEFINER 4 NULL NO varchar 288 864 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(288) select NULL
def information_schema EVENTS TIME_ZONE 5 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
def information_schema EVENTS EVENT_BODY 6 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
def information_schema EVENTS EVENT_DEFINITION 7 NULL NO longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL
def information_schema EVENTS EVENT_TYPE 8 NO varchar 9 27 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(9) select NULL
def information_schema EVENTS EXECUTE_AT 9 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select NULL
def information_schema EVENTS INTERVAL_VALUE 10 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
def information_schema EVENTS INTERVAL_FIELD 11 NULL YES enum 18 54 NULL NULL NULL utf8mb3 utf8mb3_bin enum('YEAR','QUARTER','MONTH','DAY','HOUR','MINUTE... select NULL
def information_schema EVENTS SQL_MODE 12 NULL NO set 520 1560 NULL NULL NULL utf8mb3 utf8mb3_bin set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES... select NULL
def information_schema EVENTS STARTS 13 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select NULL
def information_schema EVENTS ENDS 14 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select NULL
def information_schema EVENTS STATUS 15 NO varchar 21 63 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(21) select NULL
def information_schema EVENTS ON_COMPLETION 16 NO varchar 12 36 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(12) select NULL
def information_schema EVENTS CREATED 17 NULL NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp select NULL
def information_schema EVENTS LAST_ALTERED 18 NULL NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp select NULL
def information_schema EVENTS LAST_EXECUTED 19 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select NULL
def information_schema EVENTS EVENT_COMMENT 20 NULL NO varchar 2048 6144 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(2048) select NULL
def information_schema EVENTS ORIGINATOR 21 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
def information_schema EVENTS CHARACTER_SET_CLIENT 22 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema EVENTS COLLATION_CONNECTION 23 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema EVENTS DATABASE_COLLATION 24 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema FILES FILE_ID 1 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
def information_schema FILES FILE_NAME 2 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select NULL
def information_schema FILES FILE_TYPE 3 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
def information_schema FILES TABLESPACE_NAME 4 NULL NO varchar 268 804 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(268) select NULL
def information_schema FILES TABLE_CATALOG 5 NO char 0 0 NULL NULL NULL utf8mb3 utf8mb3_general_ci char(0) select NULL
def information_schema FILES TABLE_SCHEMA 6 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
def information_schema FILES TABLE_NAME 7 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
def information_schema FILES LOGFILE_GROUP_NAME 8 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
def information_schema FILES LOGFILE_GROUP_NUMBER 9 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
def information_schema FILES ENGINE 10 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema FILES FULLTEXT_KEYS 11 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
def information_schema FILES DELETED_ROWS 12 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
def information_schema FILES UPDATE_COUNT 13 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE COLUMN_KEY EXTRA PRIVILEGES COLUMN_COMMENT GENERATION_EXPRESSION SRS_ID  
def information_schema FILES FREE_EXTENTS 14 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
def information_schema FILES TOTAL_EXTENTS 15 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
def information_schema FILES EXTENT_SIZE 16 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
def information_schema FILES INITIAL_SIZE 17 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
def information_schema FILES MAXIMUM_SIZE 18 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
def information_schema FILES AUTOEXTEND_SIZE 19 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
def information_schema FILES CREATION_TIME 20 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
def information_schema FILES LAST_UPDATE_TIME 21 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
def information_schema FILES LAST_ACCESS_TIME 22 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
def information_schema FILES RECOVER_TIME 23 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
def information_schema FILES TRANSACTION_COUNTER 24 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
def information_schema FILES VERSION 25 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
def information_schema FILES ROW_FORMAT 26 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
def information_schema FILES TABLE_ROWS 27 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
def information_schema FILES AVG_ROW_LENGTH 28 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
def information_schema FILES DATA_LENGTH 29 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
def information_schema FILES MAX_DATA_LENGTH 30 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
def information_schema FILES INDEX_LENGTH 31 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
def information_schema FILES DATA_FREE 32 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
def information_schema FILES CREATE_TIME 33 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
def information_schema FILES UPDATE_TIME 34 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
def information_schema FILES CHECK_TIME 35 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
def information_schema FILES CHECKSUM 36 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
def information_schema FILES STATUS 37 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
def information_schema FILES EXTRA 38 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
def information_schema INNODB_DATAFILES SPACE 1 NULL YES varbinary 256 256 NULL NULL NULL NULL NULL varbinary(256) select NULL
def information_schema INNODB_DATAFILES PATH 2 NULL NO varchar 512 1536 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(512) select NULL
def information_schema INNODB_FOREIGN ID 1 NULL YES varchar 129 387 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(129) select NULL
def information_schema INNODB_FOREIGN FOR_NAME 2 NULL YES varchar 129 387 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(129) select NULL
def information_schema INNODB_FOREIGN REF_NAME 3 NULL YES varchar 129 387 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(129) select NULL
def information_schema INNODB_FOREIGN N_COLS 4 0 NO bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
def information_schema INNODB_FOREIGN TYPE 5 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
def information_schema INNODB_FOREIGN_COLS ID 1 NULL YES varchar 129 387 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(129) select NULL
def information_schema INNODB_FOREIGN_COLS FOR_COL_NAME 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema INNODB_FOREIGN_COLS REF_COL_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema INNODB_FOREIGN_COLS POS 4 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
def information_schema INNODB_FIELDS INDEX_ID 1 NULL YES varbinary 256 256 NULL NULL NULL NULL NULL varbinary(256) select NULL
def information_schema INNODB_FIELDS NAME 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema INNODB_FIELDS POS 3 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
def information_schema INNODB_TABLESPACES_BRIEF SPACE 1 NULL YES varbinary 256 256 NULL NULL NULL NULL NULL varbinary(256) select NULL
def information_schema INNODB_TABLESPACES_BRIEF NAME 2 NULL NO varchar 268 804 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(268) select NULL
def information_schema INNODB_TABLESPACES_BRIEF PATH 3 NULL NO varchar 512 1536 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(512) select NULL
def information_schema INNODB_TABLESPACES_BRIEF FLAG 4 NULL YES varbinary 256 256 NULL NULL NULL NULL NULL varbinary(256) select NULL
def information_schema INNODB_TABLESPACES_BRIEF SPACE_TYPE 5 NO varchar 7 21 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(7) select NULL
def information_schema KEY_COLUMN_USAGE CONSTRAINT_CATALOG 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema KEY_COLUMN_USAGE CONSTRAINT_SCHEMA 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema KEY_COLUMN_USAGE CONSTRAINT_NAME 3 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema KEY_COLUMN_USAGE TABLE_CATALOG 4 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema KEY_COLUMN_USAGE TABLE_SCHEMA 5 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema KEY_COLUMN_USAGE TABLE_NAME 6 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema KEY_COLUMN_USAGE COLUMN_NAME 7 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema KEY_COLUMN_USAGE ORDINAL_POSITION 8 0 NO int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
def information_schema KEY_COLUMN_USAGE POSITION_IN_UNIQUE_CONSTRAINT 9 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
def information_schema KEY_COLUMN_USAGE REFERENCED_TABLE_SCHEMA 10 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema KEY_COLUMN_USAGE REFERENCED_TABLE_NAME 11 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema KEY_COLUMN_USAGE REFERENCED_COLUMN_NAME 12 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema KEYWORDS WORD 1 NULL YES varchar 128 512 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(128) select NULL
def information_schema KEYWORDS RESERVED 2 NULL YES int NULL NULL 10 0 NULL NULL NULL int select NULL
def information_schema PARAMETERS SPECIFIC_CATALOG 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema PARAMETERS SPECIFIC_SCHEMA 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema PARAMETERS SPECIFIC_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema PARAMETERS ORDINAL_POSITION 4 0 NO bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
def information_schema PARAMETERS PARAMETER_MODE 5 NULL YES varchar 5 15 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(5) select NULL
def information_schema PARAMETERS PARAMETER_NAME 6 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema PARAMETERS DATA_TYPE 7 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL
def information_schema PARAMETERS CHARACTER_MAXIMUM_LENGTH 8 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
def information_schema PARAMETERS CHARACTER_OCTET_LENGTH 9 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
def information_schema PARAMETERS NUMERIC_PRECISION 10 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
def information_schema PARAMETERS NUMERIC_SCALE 11 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
def information_schema PARAMETERS DATETIME_PRECISION 12 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
def information_schema PARAMETERS CHARACTER_SET_NAME 13 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema PARAMETERS COLLATION_NAME 14 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema PARAMETERS DTD_IDENTIFIER 15 NULL NO mediumtext 16777215 16777215 NULL NULL NULL utf8mb3 utf8mb3_bin mediumtext select NULL
def information_schema PARAMETERS ROUTINE_TYPE 16 NULL NO enum 9 27 NULL NULL NULL utf8mb3 utf8mb3_bin enum('FUNCTION','PROCEDURE') select NULL
def information_schema PARTITIONS TABLE_CATALOG 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema PARTITIONS TABLE_SCHEMA 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema PARTITIONS TABLE_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema PARTITIONS PARTITION_NAME 4 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema PARTITIONS SUBPARTITION_NAME 5 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema PARTITIONS PARTITION_ORDINAL_POSITION 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
def information_schema PARTITIONS SUBPARTITION_ORDINAL_POSITION 7 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
def information_schema PARTITIONS PARTITION_METHOD 8 NULL YES varchar 13 39 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(13) select NULL
def information_schema PARTITIONS SUBPARTITION_METHOD 9 NULL YES varchar 13 39 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(13) select NULL
def information_schema PARTITIONS PARTITION_EXPRESSION 10 NULL YES varchar 2048 6144 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(2048) select NULL
def information_schema PARTITIONS SUBPARTITION_EXPRESSION 11 NULL YES varchar 2048 6144 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(2048) select NULL
def information_schema PARTITIONS PARTITION_DESCRIPTION 12 NULL YES text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select NULL
def information_schema PARTITIONS TABLE_ROWS 13 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
def information_schema PARTITIONS AVG_ROW_LENGTH 14 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
def information_schema PARTITIONS DATA_LENGTH 15 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
def information_schema PARTITIONS MAX_DATA_LENGTH 16 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
def information_schema PARTITIONS INDEX_LENGTH 17 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
def information_schema PARTITIONS DATA_FREE 18 NULL YES bigint NULL NULL 20 0 NULL NULL NULL bigint unsigned select NULL
def information_schema PARTITIONS CREATE_TIME 19 NULL NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp select NULL
def information_schema PARTITIONS UPDATE_TIME 20 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select NULL
def information_schema PARTITIONS CHECK_TIME 21 NULL YES datetime NULL NULL NULL NULL 0 NULL NULL datetime select NULL
def information_schema PARTITIONS CHECKSUM 22 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
def information_schema PARTITIONS PARTITION_COMMENT 23 NULL NO text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select NULL
def information_schema PARTITIONS NODEGROUP 24 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
def information_schema PARTITIONS TABLESPACE_NAME 25 NULL YES varchar 268 804 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(268) select NULL
def information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE COLUMN_KEY EXTRA PRIVILEGES COLUMN_COMMENT GENERATION_EXPRESSION SRS_ID  
def information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema REFERENTIAL_CONSTRAINTS CONSTRAINT_NAME 3 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_CATALOG 4 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_SCHEMA 5 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema REFERENTIAL_CONSTRAINTS UNIQUE_CONSTRAINT_NAME 6 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema REFERENTIAL_CONSTRAINTS MATCH_OPTION 7 NULL NO enum 7 21 NULL NULL NULL utf8mb3 utf8mb3_bin enum('NONE','PARTIAL','FULL') select NULL
def information_schema REFERENTIAL_CONSTRAINTS UPDATE_RULE 8 NULL NO enum 11 33 NULL NULL NULL utf8mb3 utf8mb3_bin enum('NO ACTION','RESTRICT','CASCADE','SET NULL','... select NULL
def information_schema REFERENTIAL_CONSTRAINTS DELETE_RULE 9 NULL NO enum 11 33 NULL NULL NULL utf8mb3 utf8mb3_bin enum('NO ACTION','RESTRICT','CASCADE','SET NULL','... select NULL
def information_schema REFERENTIAL_CONSTRAINTS TABLE_NAME 10 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema REFERENTIAL_CONSTRAINTS REFERENCED_TABLE_NAME 11 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema RESOURCE_GROUPS RESOURCE_GROUP_NAME 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema RESOURCE_GROUPS RESOURCE_GROUP_TYPE 2 NULL NO enum 6 18 NULL NULL NULL utf8mb3 utf8mb3_bin enum('SYSTEM','USER') select NULL
def information_schema RESOURCE_GROUPS RESOURCE_GROUP_ENABLED 3 NULL NO tinyint NULL NULL 3 0 NULL NULL NULL tinyint(1) select NULL
def information_schema RESOURCE_GROUPS VCPU_IDS 4 NULL YES blob 65535 65535 NULL NULL NULL NULL NULL blob select NULL
def information_schema RESOURCE_GROUPS THREAD_PRIORITY 5 NULL NO int NULL NULL 10 0 NULL NULL NULL int select NULL
def information_schema ROUTINES SPECIFIC_NAME 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema ROUTINES ROUTINE_CATALOG 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema ROUTINES ROUTINE_SCHEMA 3 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema ROUTINES ROUTINE_NAME 4 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema ROUTINES ROUTINE_TYPE 5 NULL NO enum 9 27 NULL NULL NULL utf8mb3 utf8mb3_bin enum('FUNCTION','PROCEDURE') select NULL
def information_schema ROUTINES DATA_TYPE 6 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL
def information_schema ROUTINES CHARACTER_MAXIMUM_LENGTH 7 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
def information_schema ROUTINES CHARACTER_OCTET_LENGTH 8 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
def information_schema ROUTINES NUMERIC_PRECISION 9 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
def information_schema ROUTINES NUMERIC_SCALE 10 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
def information_schema ROUTINES DATETIME_PRECISION 11 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
def information_schema ROUTINES CHARACTER_SET_NAME 12 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema ROUTINES COLLATION_NAME 13 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema ROUTINES DTD_IDENTIFIER 14 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL
def information_schema ROUTINES ROUTINE_BODY 15 NO varchar 8 24 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(8) select NULL
def information_schema ROUTINES ROUTINE_DEFINITION 16 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL
def information_schema ROUTINES EXTERNAL_NAME 17 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
def information_schema ROUTINES EXTERNAL_LANGUAGE 18 SQL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(64) select NULL
def information_schema ROUTINES PARAMETER_STYLE 19 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
def information_schema ROUTINES IS_DETERMINISTIC 20 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
def information_schema ROUTINES SQL_DATA_ACCESS 21 NULL NO enum 17 51 NULL NULL NULL utf8mb3 utf8mb3_bin enum('CONTAINS SQL','NO SQL','READS SQL DATA','MOD... select NULL
def information_schema ROUTINES SQL_PATH 22 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
def information_schema ROUTINES SECURITY_TYPE 23 NULL NO enum 7 21 NULL NULL NULL utf8mb3 utf8mb3_bin enum('DEFAULT','INVOKER','DEFINER') select NULL
def information_schema ROUTINES CREATED 24 NULL NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp select NULL
def information_schema ROUTINES LAST_ALTERED 25 NULL NO timestamp NULL NULL NULL NULL 0 NULL NULL timestamp select NULL
def information_schema ROUTINES SQL_MODE 26 NULL NO set 520 1560 NULL NULL NULL utf8mb3 utf8mb3_bin set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES... select NULL
def information_schema ROUTINES ROUTINE_COMMENT 27 NULL NO text 65535 65535 NULL NULL NULL utf8mb3 utf8mb3_bin text select NULL
def information_schema ROUTINES DEFINER 28 NULL NO varchar 288 864 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(288) select NULL
def information_schema ROUTINES CHARACTER_SET_CLIENT 29 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema ROUTINES COLLATION_CONNECTION 30 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema ROUTINES DATABASE_COLLATION 31 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema SCHEMATA CATALOG_NAME 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema SCHEMATA SCHEMA_NAME 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema SCHEMATA DEFAULT_CHARACTER_SET_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema SCHEMATA DEFAULT_COLLATION_NAME 4 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(64) select NULL
def information_schema SCHEMATA SQL_PATH 5 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
def information_schema SCHEMATA DEFAULT_ENCRYPTION 6 NULL NO enum 3 9 NULL NULL NULL utf8mb3 utf8mb3_bin enum('NO','YES') select NULL
def information_schema SCHEMATA_EXTENSIONS CATALOG_NAME 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema SCHEMATA_EXTENSIONS SCHEMA_NAME 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema SCHEMATA_EXTENSIONS OPTIONS 3 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
def information_schema ST_SPATIAL_REFERENCE_SYSTEMS SRS_NAME 1 NULL NO varchar 80 240 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(80) select NULL
def information_schema ST_SPATIAL_REFERENCE_SYSTEMS SRS_ID 2 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
def information_schema ST_SPATIAL_REFERENCE_SYSTEMS ORGANIZATION 3 NULL YES varchar 256 768 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(256) select NULL
def information_schema ST_SPATIAL_REFERENCE_SYSTEMS ORGANIZATION_COORDSYS_ID 4 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
def information_schema ST_SPATIAL_REFERENCE_SYSTEMS DEFINITION 5 NULL NO varchar 4096 12288 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(4096) select NULL
def information_schema ST_SPATIAL_REFERENCE_SYSTEMS DESCRIPTION 6 NULL YES varchar 2048 6144 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(2048) select NULL
def information_schema ST_UNITS_OF_MEASURE UNIT_NAME 1 NULL YES varchar 255 1020 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(255) select NULL
def information_schema ST_UNITS_OF_MEASURE UNIT_TYPE 2 NULL YES varchar 7 28 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(7) select NULL
def information_schema ST_UNITS_OF_MEASURE CONVERSION_FACTOR 3 NULL YES double NULL NULL 22 NULL NULL NULL NULL double select NULL
def information_schema ST_UNITS_OF_MEASURE DESCRIPTION 4 NULL YES varchar 255 1020 NULL NULL NULL utf8mb4 utf8mb4_0900_ai_ci varchar(255) select NULL
def information_schema ST_GEOMETRY_COLUMNS TABLE_CATALOG 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema ST_GEOMETRY_COLUMNS TABLE_SCHEMA 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema ST_GEOMETRY_COLUMNS TABLE_NAME 3 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema ST_GEOMETRY_COLUMNS COLUMN_NAME 4 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema ST_GEOMETRY_COLUMNS SRS_NAME 5 NULL YES varchar 80 240 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(80) select NULL
def information_schema ST_GEOMETRY_COLUMNS SRS_ID 6 NULL YES int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
def information_schema ST_GEOMETRY_COLUMNS GEOMETRY_TYPE_NAME 7 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL
def information_schema STATISTICS TABLE_CATALOG 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema STATISTICS TABLE_SCHEMA 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema STATISTICS TABLE_NAME 3 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema STATISTICS NON_UNIQUE 4 0 NO int NULL NULL 10 0 NULL NULL NULL int select NULL
def information_schema STATISTICS INDEX_SCHEMA 5 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema STATISTICS INDEX_NAME 6 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema STATISTICS SEQ_IN_INDEX 7 NULL NO int NULL NULL 10 0 NULL NULL NULL int unsigned select NULL
def information_schema STATISTICS COLUMN_NAME 8 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema STATISTICS COLLATION 9 NULL YES varchar 1 3 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(1) select NULL
def information_schema STATISTICS CARDINALITY 10 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
def information_schema STATISTICS SUB_PART 11 NULL YES bigint NULL NULL 19 0 NULL NULL NULL bigint select NULL
def information_schema STATISTICS PACKED 12 NULL YES binary 0 0 NULL NULL NULL NULL NULL binary(0) select NULL
def information_schema STATISTICS NULLABLE 13 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
def information_schema STATISTICS INDEX_TYPE 14 NO varchar 11 33 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(11) select NULL
def information_schema STATISTICS COMMENT 15 NO varchar 8 24 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(8) select NULL
def information_schema STATISTICS INDEX_COMMENT 16 NULL NO varchar 2048 6144 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(2048) select NULL
def information_schema STATISTICS IS_VISIBLE 17 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_general_ci varchar(3) select NULL
def information_schema STATISTICS EXPRESSION 18 NULL YES longtext 4294967295 4294967295 NULL NULL NULL utf8mb3 utf8mb3_bin longtext select NULL
def information_schema TABLE_CONSTRAINTS CONSTRAINT_CATALOG 1 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema TABLE_CONSTRAINTS CONSTRAINT_SCHEMA 2 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema TABLE_CONSTRAINTS CONSTRAINT_NAME 3 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema TABLE_CONSTRAINTS TABLE_SCHEMA 4 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema TABLE_CONSTRAINTS TABLE_NAME 5 NULL YES varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema TABLE_CONSTRAINTS CONSTRAINT_TYPE 6 NO varchar 11 33 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(11) select NULL
def information_schema TABLE_CONSTRAINTS ENFORCED 7 NO varchar 3 9 NULL NULL NULL utf8mb3 utf8mb3_bin varchar(3) select NULL
def information_schema TABLE_CONSTRAINTS_EXTENSIONS CONSTRAINT_CATALOG 1 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema TABLE_CONSTRAINTS_EXTENSIONS CONSTRAINT_SCHEMA 2 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select NULL
def information_schema TABLE_CONSTRAINTS_EXTENSIONS CONSTRAINT_NAME 3 NULL NO varchar 64 192 NULL NULL NULL utf8mb3 utf8mb3_tolower_ci varchar(64) select 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