🗃️ BASES / MARIADB
Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
information_schema
Nivel actual
🧬 Columnas: information_schema / PARAMETERS
16| Campo | Tipo | Null | Key | Default | Extra |
|---|
| SPECIFIC_CATALOG | varchar(512) | NO | | | |
| SPECIFIC_SCHEMA | varchar(64) | NO | | | |
| SPECIFIC_NAME | varchar(64) | NO | | | |
| ORDINAL_POSITION | int(21) | NO | | | |
| PARAMETER_MODE | varchar(5) | YES | | | |
| PARAMETER_NAME | varchar(64) | YES | | | |
| DATA_TYPE | varchar(64) | NO | | | |
| CHARACTER_MAXIMUM_LENGTH | int(21) | YES | | | |
| CHARACTER_OCTET_LENGTH | int(21) | YES | | | |
| NUMERIC_PRECISION | int(21) | YES | | | |
| NUMERIC_SCALE | int(21) | YES | | | |
| DATETIME_PRECISION | bigint(21) unsigned | YES | | | |
| CHARACTER_SET_NAME | varchar(64) | YES | | | |
| COLLATION_NAME | varchar(64) | YES | | | |
| DTD_IDENTIFIER | longtext | NO | | | |
| ROUTINE_TYPE | varchar(9) | NO | | | |
🔬 Muestra de datos
20 filas
| SPECIFIC_CATALOG | SPECIFIC_SCHEMA | SPECIFIC_NAME | ORDINAL_POSITION | PARAMETER_MODE | PARAMETER_NAME | DATA_TYPE | CHARACTER_MAXIMUM_LENGTH | CHARACTER_OCTET_LENGTH | NUMERIC_PRECISION | NUMERIC_SCALE | DATETIME_PRECISION | CHARACTER_SET_NAME | COLLATION_NAME | DTD_IDENTIFIER | ROUTINE_TYPE |
|---|
| def | mysql | AddGeometryColumn | 1 | IN | catalog | varchar | 64 | 256 | | | | utf8mb4 | utf8mb4_uca1400_ai_ci | varchar(64) | PROCEDURE |
| def | mysql | AddGeometryColumn | 2 | IN | t_schema | varchar | 64 | 256 | | | | utf8mb4 | utf8mb4_uca1400_ai_ci | varchar(64) | PROCEDURE |
| def | mysql | AddGeometryColumn | 3 | IN | t_name | varchar | 64 | 256 | | | | utf8mb4 | utf8mb4_uca1400_ai_ci | varchar(64) | PROCEDURE |
| def | mysql | AddGeometryColumn | 4 | IN | geometry_column | varchar | 64 | 256 | | | | utf8mb4 | utf8mb4_uca1400_ai_ci | varchar(64) | PROCEDURE |
| def | mysql | AddGeometryColumn | 5 | IN | t_srid | int | | | 10 | 0 | | | | int(11) | PROCEDURE |
| def | mysql | DropGeometryColumn | 1 | IN | catalog | varchar | 64 | 256 | | | | utf8mb4 | utf8mb4_uca1400_ai_ci | varchar(64) | PROCEDURE |
| def | mysql | DropGeometryColumn | 2 | IN | t_schema | varchar | 64 | 256 | | | | utf8mb4 | utf8mb4_uca1400_ai_ci | varchar(64) | PROCEDURE |
| def | mysql | DropGeometryColumn | 3 | IN | t_name | varchar | 64 | 256 | | | | utf8mb4 | utf8mb4_uca1400_ai_ci | varchar(64) | PROCEDURE |
| def | mysql | DropGeometryColumn | 4 | IN | geometry_column | varchar | 64 | 256 | | | | utf8mb4 | utf8mb4_uca1400_ai_ci | varchar(64) | PROCEDURE |
| def | sys | create_synonym_db | 1 | IN | in_db_name | varchar | 64 | 192 | | | | utf8mb3 | utf8mb3_general_ci | varchar(64) | PROCEDURE |
| def | sys | create_synonym_db | 2 | IN | in_synonym | varchar | 64 | 192 | | | | utf8mb3 | utf8mb3_general_ci | varchar(64) | PROCEDURE |
| def | sys | diagnostics | 1 | IN | in_max_runtime | int | | | 10 | 0 | | | | int(10) unsigned | PROCEDURE |
| def | sys | diagnostics | 2 | IN | in_interval | int | | | 10 | 0 | | | | int(10) unsigned | PROCEDURE |
| def | sys | diagnostics | 3 | IN | in_auto_config | enum | 7 | 21 | | | | utf8mb3 | utf8mb3_general_ci | enum('current','medium','full') | PROCEDURE |
| def | sys | execute_prepared_stmt | 1 | IN | in_query | longtext | 2147483647 | 2147483647 | | | | utf8mb3 | utf8mb3_general_ci | longtext | PROCEDURE |
| def | sys | extract_schema_from_file_name | 0 | | | varchar | 64 | 192 | | | | utf8mb3 | utf8mb3_general_ci | varchar(64) | FUNCTION |
| def | sys | extract_schema_from_file_name | 1 | IN | path | varchar | 512 | 1536 | | | | utf8mb3 | utf8mb3_general_ci | varchar(512) | FUNCTION |
| def | sys | extract_table_from_file_name | 0 | | | varchar | 64 | 192 | | | | utf8mb3 | utf8mb3_general_ci | varchar(64) | FUNCTION |
| def | sys | extract_table_from_file_name | 1 | IN | path | varchar | 512 | 1536 | | | | utf8mb3 | utf8mb3_general_ci | varchar(512) | FUNCTION |
| def | sys | format_bytes | 0 | | | text | 65535 | 65535 | | | | utf8mb3 | utf8mb3_general_ci | text | FUNCTION |