🗃️ 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 / INNODB_SYS_INDEXES
8| Campo | Tipo | Null | Key | Default | Extra |
|---|
| INDEX_ID | bigint(21) unsigned | NO | | | |
| NAME | varchar(64) | NO | | | |
| TABLE_ID | bigint(21) unsigned | NO | | | |
| TYPE | int(11) | NO | | | |
| N_FIELDS | int(11) | NO | | | |
| PAGE_NO | int(11) | YES | | | |
| SPACE | int(11) | YES | | | |
| MERGE_THRESHOLD | int(11) | NO | | | |
🔬 Muestra de datos
20 filas
| INDEX_ID | NAME | TABLE_ID | TYPE | N_FIELDS | PAGE_NO | SPACE | MERGE_THRESHOLD |
|---|
| 11 | ID_IND | 11 | 3 | 1 | 45 | 0 | 50 |
| 12 | FOR_IND | 11 | 0 | 1 | 46 | 0 | 50 |
| 13 | REF_IND | 11 | 0 | 1 | 47 | 0 | 50 |
| 14 | ID_IND | 12 | 3 | 2 | 48 | 0 | 50 |
| 15 | BASE_IDX | 13 | 3 | 3 | 49 | 0 | 50 |
| 16 | PRIMARY | 14 | 3 | 2 | 3 | 4 | 50 |
| 17 | PRIMARY | 15 | 3 | 4 | 3 | 5 | 50 |
| 18 | PRIMARY | 16 | 3 | 1 | 3 | 6 | 50 |
| 19 | commit_id | 16 | 2 | 1 | 4 | 6 | 50 |
| 20 | begin_timestamp | 16 | 0 | 1 | 5 | 6 | 50 |
| 21 | commit_timestamp | 16 | 0 | 2 | 6 | 6 | 50 |
| 22 | PRIMARY | 17 | 3 | 2 | 3 | 7 | 50 |
| 23 | PRIMARY | 18 | 3 | 1 | 3 | 8 | 50 |
| 24 | PRIMARY | 19 | 3 | 1 | 3 | 9 | 50 |
| 25 | db_name | 19 | 2 | 3 | 4 | 9 | 50 |
| 26 | PRIMARY | 20 | 3 | 1 | 3 | 10 | 50 |
| 27 | username | 20 | 0 | 4 | 4 | 10 | 50 |
| 28 | PRIMARY | 21 | 3 | 1 | 3 | 11 | 50 |
| 29 | db_name | 21 | 0 | 1 | 4 | 11 | 50 |
| 30 | PRIMARY | 22 | 3 | 1 | 3 | 12 | 50 |