🗃️ 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 / KEY_COLUMN_USAGE
12| Campo | Tipo | Null | Key | Default | Extra |
|---|
| CONSTRAINT_CATALOG | varchar(512) | NO | | | |
| CONSTRAINT_SCHEMA | varchar(64) | NO | | | |
| CONSTRAINT_NAME | varchar(64) | NO | | | |
| TABLE_CATALOG | varchar(512) | NO | | | |
| TABLE_SCHEMA | varchar(64) | NO | | | |
| TABLE_NAME | varchar(64) | NO | | | |
| COLUMN_NAME | varchar(64) | NO | | | |
| ORDINAL_POSITION | bigint(10) | NO | | | |
| POSITION_IN_UNIQUE_CONSTRAINT | bigint(10) | YES | | | |
| REFERENCED_TABLE_SCHEMA | varchar(64) | YES | | | |
| REFERENCED_TABLE_NAME | varchar(64) | YES | | | |
| REFERENCED_COLUMN_NAME | varchar(64) | YES | | | |
🔬 Muestra de datos
20 filas
| CONSTRAINT_CATALOG | CONSTRAINT_SCHEMA | CONSTRAINT_NAME | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | POSITION_IN_UNIQUE_CONSTRAINT | REFERENCED_TABLE_SCHEMA | REFERENCED_TABLE_NAME | REFERENCED_COLUMN_NAME |
|---|
| def | victorias | PRIMARY | def | victorias | bench_runs | id | 1 | | | | |
| def | victorias | PRIMARY | def | victorias | registros | id | 1 | | | | |
| def | sys | PRIMARY | def | sys | sys_config | variable | 1 | | | | |
| def | cueva_test | PRIMARY | def | cueva_test | bench_runs | id | 1 | | | | |
| def | cueva_test | PRIMARY | def | cueva_test | registros | id | 1 | | | | |
| def | phpmyadmin | PRIMARY | def | phpmyadmin | pma__column_info | id | 1 | | | | |
| def | phpmyadmin | db_name | def | phpmyadmin | pma__column_info | db_name | 1 | | | | |
| def | phpmyadmin | db_name | def | phpmyadmin | pma__column_info | table_name | 2 | | | | |
| def | phpmyadmin | db_name | def | phpmyadmin | pma__column_info | column_name | 3 | | | | |
| def | phpmyadmin | PRIMARY | def | phpmyadmin | pma__tracking | db_name | 1 | | | | |
| def | phpmyadmin | PRIMARY | def | phpmyadmin | pma__tracking | table_name | 2 | | | | |
| def | phpmyadmin | PRIMARY | def | phpmyadmin | pma__tracking | version | 3 | | | | |
| def | phpmyadmin | PRIMARY | def | phpmyadmin | pma__history | id | 1 | | | | |
| def | phpmyadmin | PRIMARY | def | phpmyadmin | pma__userconfig | username | 1 | | | | |
| def | phpmyadmin | PRIMARY | def | phpmyadmin | pma__savedsearches | id | 1 | | | | |
| def | phpmyadmin | u_savedsearches_username_dbname | def | phpmyadmin | pma__savedsearches | username | 1 | | | | |
| def | phpmyadmin | u_savedsearches_username_dbname | def | phpmyadmin | pma__savedsearches | db_name | 2 | | | | |
| def | phpmyadmin | u_savedsearches_username_dbname | def | phpmyadmin | pma__savedsearches | search_name | 3 | | | | |
| def | phpmyadmin | PRIMARY | def | phpmyadmin | pma__designer_settings | username | 1 | | | | |
| def | phpmyadmin | PRIMARY | def | phpmyadmin | pma__table_uiprefs | username | 1 | | | | |