La selezione corrente non contiene un campo unico. Modifica griglia, checkbox, Modifica, Copia ed Elimina potrebbero non essere disponibili.
Mostro le righe 0 - ...
Questa vista ha, come minimo, questo numero di righe. Per informazioni controlla la documentazione. (La query ha impiegato 0.0331 secondi.) [CHARACTER_OCTET_LENGTH: 4294967295... - 4294967295...]
SELECT * FROM `COLUMNS` ORDER BY `CHARACTER_OCTET_LENGTH` DESC
| Filtra righe: |
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | COLUMN_DEFAULT | IS_NULLABLE | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH |
CHARACTER_OCTET_LENGTH 1
|
NUMERIC_PRECISION | NUMERIC_SCALE | DATETIME_PRECISION | CHARACTER_SET_NAME | COLLATION_NAME | COLUMN_TYPE | COLUMN_KEY | EXTRA | PRIVILEGES | COLUMN_COMMENT | IS_GENERATED | GENERATION_EXPRESSION | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| def | information_schema | ALL_PLUGINS | PLUGIN_DESCRIPTION | 9 | NULL | YES | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select | NEVER | NULL | ||||
| def | information_schema | CHECK_CONSTRAINTS | CHECK_CLAUSE | 5 | NULL | NO | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select | NEVER | NULL | ||||
| def | information_schema | COLUMNS | COLUMN_DEFAULT | 6 | NULL | YES | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select | NEVER | NULL | ||||
| def | information_schema | COLUMNS | COLUMN_TYPE | 16 | NULL | NO | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select | NEVER | NULL | ||||
| def | information_schema | COLUMNS | GENERATION_EXPRESSION | 22 | NULL | YES | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select | NEVER | NULL | ||||
| def | information_schema | EVENTS | EVENT_DEFINITION | 7 | NULL | NO | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select | NEVER | NULL | ||||
| def | information_schema | OPTIMIZER_TRACE | QUERY | 1 | NULL | NO | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select | NEVER | NULL | ||||
| def | information_schema | OPTIMIZER_TRACE | TRACE | 2 | NULL | NO | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select | NEVER | NULL | ||||
| def | information_schema | PARAMETERS | DTD_IDENTIFIER | 15 | NULL | NO | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select | NEVER | NULL | ||||
| def | information_schema | PARTITIONS | PARTITION_EXPRESSION | 10 | NULL | YES | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select | NEVER | NULL | ||||
| def | information_schema | PARTITIONS | SUBPARTITION_EXPRESSION | 11 | NULL | YES | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select | NEVER | NULL | ||||
| def | information_schema | PARTITIONS | PARTITION_DESCRIPTION | 12 | NULL | YES | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select | NEVER | NULL | ||||
| def | information_schema | PLUGINS | PLUGIN_DESCRIPTION | 9 | NULL | YES | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select | NEVER | NULL | ||||
| def | information_schema | PROCESSLIST | INFO | 8 | NULL | YES | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select | NEVER | NULL | ||||
| def | information_schema | ROUTINES | DTD_IDENTIFIER | 14 | NULL | YES | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select | NEVER | NULL | ||||
| def | information_schema | ROUTINES | ROUTINE_DEFINITION | 16 | NULL | YES | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select | NEVER | NULL | ||||
| def | information_schema | ROUTINES | ROUTINE_COMMENT | 27 | NULL | NO | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select | NEVER | NULL | ||||
| def | information_schema | SYSTEM_VARIABLES | ENUM_VALUE_LIST | 12 | NULL | YES | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select | NEVER | NULL | ||||
| def | information_schema | TRIGGERS | ACTION_CONDITION | 9 | NULL | YES | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select | NEVER | NULL | ||||
| def | information_schema | TRIGGERS | ACTION_STATEMENT | 10 | NULL | NO | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select | NEVER | NULL | ||||
| def | information_schema | VIEWS | VIEW_DEFINITION | 4 | NULL | NO | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select | NEVER | NULL | ||||
| def | phpmyadmin | pma__tracking | data_sql | 8 | NULL | YES | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_bin | longtext | select,insert,update,references | NEVER | NULL | ||||
| def | performance_schema | events_statements_current | SQL_TEXT | 10 | NULL | YES | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select,insert,update,references | The SQL statement, or NULL if the command is not a... | NEVER | NULL | |||
| def | performance_schema | events_statements_current | DIGEST_TEXT | 12 | NULL | YES | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select,insert,update,references | Statement digest text. | NEVER | NULL | |||
| def | performance_schema | events_statements_history | SQL_TEXT | 10 | NULL | YES | longtext | 4294967295 | 4294967295 | NULL | NULL | NULL | utf8 | utf8_general_ci | longtext | select,insert,update,references | The SQL statement, or NULL if the command is not a... | NEVER | NULL |
| Filtra righe: |