SELECT * FROM `PARTITIONS`
|
TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | PARTITION_NAME | SUBPARTITION_NAME | PARTITION_ORDINAL_POSITION | SUBPARTITION_ORDINAL_POSITION | PARTITION_METHOD | SUBPARTITION_METHOD | PARTITION_EXPRESSION | SUBPARTITION_EXPRESSION | PARTITION_DESCRIPTION | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | CREATE_TIME | UPDATE_TIME | CHECK_TIME | CHECKSUM | PARTITION_COMMENT | NODEGROUP | TABLESPACE_NAME | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
def | DBMS | Products | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | 3276 | 16384 | 0 | 0 | 0 | 2024-09-24 20:39:10 | 2024-09-24 20:39:10 | NULL | NULL | NULL | |||
def | DBMS | Sales | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | 3276 | 16384 | 0 | 0 | 0 | 2024-09-24 20:39:10 | 2024-09-24 20:39:10 | NULL | NULL | NULL | |||
def | Libro | author | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | 3276 | 16384 | 0 | 0 | 0 | 2024-09-24 20:39:36 | 2024-09-24 20:39:36 | NULL | NULL | NULL | |||
def | Libro | book_review | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | 3276 | 16384 | 0 | 0 | 0 | 2024-09-24 20:39:36 | 2024-09-24 20:39:37 | NULL | NULL | NULL | |||
def | Libro | book_reviews | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 7 | 2340 | 16384 | 0 | 0 | 0 | 2024-09-24 20:39:37 | 2024-09-24 20:39:37 | NULL | NULL | NULL | |||
def | Libro | books | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | 3276 | 16384 | 0 | 0 | 0 | 2024-09-24 20:39:36 | 2024-09-24 20:39:36 | NULL | NULL | NULL | |||
def | hospital | ayudantes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | 3276 | 16384 | 0 | 0 | 0 | 2024-09-24 20:38:32 | 2024-09-24 20:38:33 | NULL | NULL | NULL | |||
def | hospital | cafeteria | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | 3276 | 16384 | 0 | 0 | 0 | 2024-09-24 20:38:33 | 2024-09-24 20:38:33 | NULL | NULL | NULL | |||
def | hospital | doctores | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | 3276 | 16384 | 0 | 0 | 0 | 2024-09-24 20:38:33 | 2024-09-24 20:38:33 | NULL | NULL | NULL | |||
def | hospital | enfermeros | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | 3276 | 16384 | 0 | 0 | 0 | 2024-09-24 20:38:33 | 2024-09-24 20:38:33 | NULL | NULL | NULL | |||
def | hospital | pacientes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | 3276 | 16384 | 0 | 0 | 0 | 2024-09-24 20:38:33 | 2024-09-24 20:38:34 | NULL | NULL | NULL | |||
def | hospital | urgencias | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | 3276 | 16384 | 0 | 0 | 0 | 2024-09-24 20:38:34 | 2024-09-24 20:38:34 | NULL | NULL | NULL | |||
def | hospital | visitantes | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 5 | 3276 | 16384 | 0 | 0 | 0 | 2024-09-24 20:38:34 | 2024-09-24 20:38:34 | NULL | NULL | NULL | |||
def | information_schema | CHARACTER_SETS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | CHECK_CONSTRAINTS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | COLLATIONS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | COLUMNS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | COLUMN_PRIVILEGES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | COLUMN_STATISTICS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | ENGINES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | EVENTS | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | FILES | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | INNODB_BUFFER_PAGE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:34 | NULL | NULL | NULL | NULL | |||
def | information_schema | INNODB_BUFFER_PAGE_LRU | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | 0 | 2019-10-30 15:09:34 | NULL | NULL | NULL | NULL |
|