🗃️ 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_FIELDS
3| Campo | Tipo | Null | Key | Default | Extra |
|---|
| INDEX_ID | bigint(21) unsigned | NO | | | |
| NAME | varchar(64) | NO | | | |
| POS | int(11) unsigned | NO | | | |
🔬 Muestra de datos
20 filas
| INDEX_ID | NAME | POS |
|---|
| 11 | ID | 0 |
| 12 | FOR_NAME | 0 |
| 13 | REF_NAME | 0 |
| 14 | ID | 0 |
| 14 | POS | 1 |
| 15 | TABLE_ID | 0 |
| 15 | POS | 1 |
| 15 | BASE_POS | 2 |
| 16 | database_name | 0 |
| 16 | table_name | 1 |
| 17 | database_name | 0 |
| 17 | table_name | 1 |
| 17 | index_name | 2 |
| 17 | stat_name | 3 |
| 18 | transaction_id | 0 |
| 19 | commit_id | 0 |
| 20 | begin_timestamp | 0 |
| 21 | commit_timestamp | 0 |
| 21 | transaction_id | 1 |
| 22 | domain_id | 0 |