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 | Consultorio | Medico | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-09-27 13:39:50 | NULL | NULL | NULL | NULL | |||
def | Consultorio | paciente | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | 0 | 16384 | 0 | 0 | 0 | 2024-09-27 13:39:50 | NULL | 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 | |||
def | information_schema | INNODB_BUFFER_POOL_STATS | 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_CACHED_INDEXES | 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_CMP | 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_CMPMEM | 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_CMPMEM_RESET | 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_CMP_PER_INDEX | 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_CMP_PER_INDEX_RESET | 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_CMP_RESET | 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_COLUMNS | 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_DATAFILES | 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_FIELDS | 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 |
|