🗃️ BASES / MARIADB
Mirar bases, hurgar tablas, ver columnas y muestra. Borrado de DB desactivado para evitar una tragedia bíblica.
🧬 Columnas: sys / schema_auto_increment_columns
10| Campo | Tipo | Null | Key | Default | Extra |
|---|
| table_schema | varchar(64) | NO | | | |
| table_name | varchar(64) | NO | | | |
| column_name | varchar(64) | NO | | | |
| data_type | varchar(64) | NO | | | |
| column_type | longtext | NO | | | |
| is_signed | int(1) | NO | | 0 | |
| is_unsigned | int(1) | NO | | 0 | |
| max_value | bigint(21) unsigned | YES | | | |
| auto_increment | bigint(21) unsigned | YES | | | |
| auto_increment_ratio | decimal(25,4) unsigned | YES | | | |
🔬 Muestra de datos
16 filas
| table_schema | table_name | column_name | data_type | column_type | is_signed | is_unsigned | max_value | auto_increment | auto_increment_ratio |
|---|
| cueva_test | bench_runs | id | int | int(10) unsigned | 0 | 1 | 4294967295 | 2 | 0.0000 |
| phpmyadmin | pma__column_info | id | int | int(5) unsigned | 0 | 1 | 4294967295 | 1 | 0.0000 |
| phpmyadmin | pma__savedsearches | id | int | int(5) unsigned | 0 | 1 | 4294967295 | 1 | 0.0000 |
| phpmyadmin | pma__export_templates | id | int | int(5) unsigned | 0 | 1 | 4294967295 | 1 | 0.0000 |
| phpmyadmin | pma__bookmark | id | int | int(10) unsigned | 0 | 1 | 4294967295 | 1 | 0.0000 |
| phpmyadmin | pma__pdf_pages | page_nr | int | int(10) unsigned | 0 | 1 | 4294967295 | 1 | 0.0000 |
| cueva_bench | bench_runs | id | int | int(10) unsigned | 0 | 1 | 4294967295 | 2 | 0.0000 |
| victorias | bench_runs | id | bigint | bigint(20) unsigned | 0 | 1 | 18446744073709551615 | 261 | 0.0000 |
| victorias | registros | id | bigint | bigint(20) unsigned | 0 | 1 | 18446744073709551615 | 2 | 0.0000 |
| cueva_test | registros | id | bigint | bigint(20) unsigned | 0 | 1 | 18446744073709551615 | 806409 | 0.0000 |
| phpmyadmin | pma__history | id | bigint | bigint(20) unsigned | 0 | 1 | 18446744073709551615 | 1 | 0.0000 |
| lista_precios_oracle_pi | espectro_frames | id | bigint | bigint(20) unsigned | 0 | 1 | 18446744073709551615 | 1 | 0.0000 |
| lista_precios_oracle_pi | productos | id | bigint | bigint(20) unsigned | 0 | 1 | 18446744073709551615 | 1568327 | 0.0000 |
| lista_precios_oracle_pi | pi_chunks | id | bigint | bigint(20) unsigned | 0 | 1 | 18446744073709551615 | 3004 | 0.0000 |
| cueva_bench | ametralla_registros | id | bigint | bigint(20) unsigned | 0 | 1 | 18446744073709551615 | 1104821 | 0.0000 |
| cueva_bench | registros_5m | id | bigint | bigint(20) unsigned | 0 | 1 | 18446744073709551615 | 6537966 | 0.0000 |