🗃️ 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_COLUMNS
6| Campo | Tipo | Null | Key | Default | Extra |
|---|
| TABLE_ID | bigint(21) unsigned | NO | | | |
| NAME | varchar(64) | NO | | | |
| POS | bigint(21) unsigned | NO | | | |
| MTYPE | int(11) | NO | | | |
| PRTYPE | int(11) | NO | | | |
| LEN | int(11) | NO | | | |
🔬 Muestra de datos
20 filas
| TABLE_ID | NAME | POS | MTYPE | PRTYPE | LEN |
|---|
| 11 | ID | 0 | 1 | 150994948 | 0 |
| 11 | FOR_NAME | 1 | 1 | 150994948 | 0 |
| 11 | REF_NAME | 2 | 1 | 150994948 | 0 |
| 11 | N_COLS | 3 | 6 | 0 | 4 |
| 12 | ID | 0 | 1 | 150994948 | 0 |
| 12 | POS | 1 | 6 | 0 | 4 |
| 12 | FOR_COL_NAME | 2 | 1 | 150994948 | 0 |
| 12 | REF_COL_NAME | 3 | 1 | 150994948 | 0 |
| 13 | TABLE_ID | 0 | 6 | 0 | 8 |
| 13 | POS | 1 | 6 | 0 | 4 |
| 13 | BASE_POS | 2 | 6 | 0 | 4 |
| 14 | database_name | 0 | 12 | 5439759 | 192 |
| 14 | table_name | 1 | 12 | 5443855 | 597 |
| 14 | last_update | 2 | 3 | 526087 | 4 |
| 14 | n_rows | 3 | 6 | 1800 | 8 |
| 14 | clustered_index_size | 4 | 6 | 1800 | 8 |
| 14 | sum_of_other_index_sizes | 5 | 6 | 1800 | 8 |
| 15 | database_name | 0 | 12 | 5439759 | 192 |
| 15 | table_name | 1 | 12 | 5443855 | 597 |
| 15 | index_name | 2 | 12 | 5439759 | 192 |