🗃️ BASES / MARIADB

Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.

Conexión DB

Tablas visibles

information_schema

Nivel actual

🧬 Columnas: information_schema / COLUMNS

Campo	Tipo	Null
TABLE_CATALOG	varchar(512)	NO
TABLE_SCHEMA	varchar(64)	NO
TABLE_NAME	varchar(64)	NO
COLUMN_NAME	varchar(64)	NO
ORDINAL_POSITION	bigint(21) unsigned	NO
COLUMN_DEFAULT	longtext	YES
IS_NULLABLE	varchar(3)	NO
DATA_TYPE	varchar(64)	NO
CHARACTER_MAXIMUM_LENGTH	bigint(21) unsigned	YES
CHARACTER_OCTET_LENGTH	bigint(21) unsigned	YES
NUMERIC_PRECISION	bigint(21) unsigned	YES
NUMERIC_SCALE	bigint(21) unsigned	YES
DATETIME_PRECISION	bigint(21) unsigned	YES
CHARACTER_SET_NAME	varchar(32)	YES
COLLATION_NAME	varchar(64)	YES
COLUMN_TYPE	longtext	NO
COLUMN_KEY	varchar(3)	NO
EXTRA	varchar(80)	NO
PRIVILEGES	varchar(80)	NO
COLUMN_COMMENT	varchar(1024)	NO
IS_GENERATED	varchar(6)	NO
GENERATION_EXPRESSION	longtext	YES
IS_SYSTEM_TIME_PERIOD_START	varchar(3)	NO
IS_SYSTEM_TIME_PERIOD_END	varchar(3)	NO

🔬 Muestra de datos

20 filas

TABLE_CATALOG	TABLE_SCHEMA	TABLE_NAME	COLUMN_NAME	ORDINAL_POSITION	IS_NULLABLE	DATA_TYPE	CHARACTER_MAXIMUM_LENGTH	CHARACTER_OCTET_LENGTH	CHARACTER_SET_NAME	COLLATION_NAME	COLUMN_TYPE	PRIVILEGES	IS_GENERATED	IS_SYSTEM_TIME_PERIOD_START	IS_SYSTEM_TIME_PERIOD_END
def	information_schema	ALL_PLUGINS	PLUGIN_NAME	1	NO	varchar	64	192	utf8mb3	utf8mb3_general_ci	varchar(64)	select	NEVER	NO	NO
def	information_schema	ALL_PLUGINS	PLUGIN_VERSION	2	NO	varchar	20	60	utf8mb3	utf8mb3_general_ci	varchar(20)	select	NEVER	NO	NO
def	information_schema	ALL_PLUGINS	PLUGIN_STATUS	3	NO	varchar	16	48	utf8mb3	utf8mb3_general_ci	varchar(16)	select	NEVER	NO	NO
def	information_schema	ALL_PLUGINS	PLUGIN_TYPE	4	NO	varchar	80	240	utf8mb3	utf8mb3_general_ci	varchar(80)	select	NEVER	NO	NO
def	information_schema	ALL_PLUGINS	PLUGIN_TYPE_VERSION	5	NO	varchar	20	60	utf8mb3	utf8mb3_general_ci	varchar(20)	select	NEVER	NO	NO
def	information_schema	ALL_PLUGINS	PLUGIN_LIBRARY	6	YES	varchar	64	192	utf8mb3	utf8mb3_general_ci	varchar(64)	select	NEVER	NO	NO
def	information_schema	ALL_PLUGINS	PLUGIN_LIBRARY_VERSION	7	YES	varchar	20	60	utf8mb3	utf8mb3_general_ci	varchar(20)	select	NEVER	NO	NO
def	information_schema	ALL_PLUGINS	PLUGIN_AUTHOR	8	YES	varchar	64	192	utf8mb3	utf8mb3_general_ci	varchar(64)	select	NEVER	NO	NO
def	information_schema	ALL_PLUGINS	PLUGIN_DESCRIPTION	9	YES	longtext	4294967295	4294967295	utf8mb3	utf8mb3_general_ci	longtext	select	NEVER	NO	NO
def	information_schema	ALL_PLUGINS	PLUGIN_LICENSE	10	NO	varchar	80	240	utf8mb3	utf8mb3_general_ci	varchar(80)	select	NEVER	NO	NO
def	information_schema	ALL_PLUGINS	LOAD_OPTION	11	NO	varchar	64	192	utf8mb3	utf8mb3_general_ci	varchar(64)	select	NEVER	NO	NO
def	information_schema	ALL_PLUGINS	PLUGIN_MATURITY	12	NO	varchar	12	36	utf8mb3	utf8mb3_general_ci	varchar(12)	select	NEVER	NO	NO
def	information_schema	ALL_PLUGINS	PLUGIN_AUTH_VERSION	13	YES	varchar	80	240	utf8mb3	utf8mb3_general_ci	varchar(80)	select	NEVER	NO	NO
def	information_schema	APPLICABLE_ROLES	GRANTEE	1	NO	varchar	385	1155	utf8mb3	utf8mb3_general_ci	varchar(385)	select	NEVER	NO	NO
def	information_schema	APPLICABLE_ROLES	ROLE_NAME	2	NO	varchar	128	384	utf8mb3	utf8mb3_general_ci	varchar(128)	select	NEVER	NO	NO
def	information_schema	APPLICABLE_ROLES	IS_GRANTABLE	3	NO	varchar	3	9	utf8mb3	utf8mb3_general_ci	varchar(3)	select	NEVER	NO	NO
def	information_schema	APPLICABLE_ROLES	IS_DEFAULT	4	YES	varchar	3	9	utf8mb3	utf8mb3_general_ci	varchar(3)	select	NEVER	NO	NO
def	information_schema	CHARACTER_SETS	CHARACTER_SET_NAME	1	NO	varchar	32	96	utf8mb3	utf8mb3_general_ci	varchar(32)	select	NEVER	NO	NO
def	information_schema	CHARACTER_SETS	DEFAULT_COLLATE_NAME	2	NO	varchar	64	192	utf8mb3	utf8mb3_general_ci	varchar(64)	select	NEVER	NO	NO
def	information_schema	CHARACTER_SETS	DESCRIPTION	3	NO	varchar	60	180	utf8mb3	utf8mb3_general_ci	varchar(60)	select	NEVER	NO	NO