🗃️ 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 / STATISTICS
17| Campo | Tipo | Null | Key | Default | Extra |
|---|
| TABLE_CATALOG | varchar(512) | NO | | | |
| TABLE_SCHEMA | varchar(64) | NO | | | |
| TABLE_NAME | varchar(64) | NO | | | |
| NON_UNIQUE | bigint(1) | NO | | | |
| INDEX_SCHEMA | varchar(64) | NO | | | |
| INDEX_NAME | varchar(64) | NO | | | |
| SEQ_IN_INDEX | int(2) unsigned | NO | | | |
| COLUMN_NAME | varchar(64) | NO | | | |
| COLLATION | varchar(1) | YES | | | |
| CARDINALITY | bigint(21) | YES | | | |
| SUB_PART | bigint(3) | YES | | | |
| PACKED | varchar(10) | YES | | | |
| NULLABLE | varchar(3) | NO | | | |
| INDEX_TYPE | varchar(16) | NO | | | |
| COMMENT | varchar(16) | YES | | | |
| INDEX_COMMENT | varchar(1024) | NO | | | |
| IGNORED | varchar(3) | NO | | | |
🔬 Muestra de datos
20 filas
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | NON_UNIQUE | INDEX_SCHEMA | INDEX_NAME | SEQ_IN_INDEX | COLUMN_NAME | COLLATION | CARDINALITY | SUB_PART | PACKED | NULLABLE | INDEX_TYPE | COMMENT | INDEX_COMMENT | IGNORED |
|---|
| def | victorias | bench_runs | 0 | victorias | PRIMARY | 1 | id | A | 241 | | | | BTREE | | | NO |
| def | victorias | bench_runs | 1 | victorias | idx_creado_en | 1 | creado_en | A | 14 | | | | BTREE | | | NO |
| def | victorias | registros | 0 | victorias | PRIMARY | 1 | id | A | 0 | | | | BTREE | | | NO |
| def | victorias | registros | 1 | victorias | idx_fecha | 1 | fecha | A | 0 | | | | BTREE | | | NO |
| def | victorias | registros | 1 | victorias | idx_sistema | 1 | sistema | A | 0 | | | | BTREE | | | NO |
| def | victorias | registros | 1 | victorias | ft_busqueda | 1 | titulo | | | | | | FULLTEXT | | | NO |
| def | victorias | registros | 1 | victorias | ft_busqueda | 2 | contexto | | | | | YES | FULLTEXT | | | NO |
| def | victorias | registros | 1 | victorias | ft_busqueda | 3 | problema | | | | | | FULLTEXT | | | NO |
| def | victorias | registros | 1 | victorias | ft_busqueda | 4 | diagnostico | | | | | | FULLTEXT | | | NO |
| def | victorias | registros | 1 | victorias | ft_busqueda | 5 | solucion | | | | | | FULLTEXT | | | NO |
| def | victorias | registros | 1 | victorias | ft_busqueda | 6 | resultado | | | | | | FULLTEXT | | | NO |
| def | victorias | registros | 1 | victorias | ft_busqueda | 7 | etiquetas | | | | | YES | FULLTEXT | | | NO |
| def | sys | sys_config | 0 | sys | PRIMARY | 1 | variable | A | 6 | | | | BTREE | | | NO |
| def | cueva_test | bench_runs | 0 | cueva_test | PRIMARY | 1 | id | A | 0 | | | | BTREE | | | NO |
| def | cueva_test | registros | 0 | cueva_test | PRIMARY | 1 | id | A | 497010 | | | | BTREE | | | NO |
| def | cueva_test | registros | 1 | cueva_test | idx_lote | 1 | lote | A | 24 | | | | BTREE | | | NO |
| def | cueva_test | registros | 1 | cueva_test | idx_origen | 1 | origen | A | 1 | | | | BTREE | | | NO |
| def | cueva_test | registros | 1 | cueva_test | idx_creado | 1 | creado_en | A | 24 | | | YES | BTREE | | | NO |
| def | phpmyadmin | pma__column_info | 0 | phpmyadmin | PRIMARY | 1 | id | A | 0 | | | | BTREE | | | NO |
| def | phpmyadmin | pma__column_info | 0 | phpmyadmin | db_name | 1 | db_name | A | 0 | | | | BTREE | | | NO |