SELECT * FROM `TABLES`
|
TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | ENGINE | VERSION | ROW_FORMAT | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | AUTO_INCREMENT | CREATE_TIME | UPDATE_TIME | CHECK_TIME | TABLE_COLLATION | CHECKSUM | CREATE_OPTIONS | TABLE_COMMENT | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
def | Rachelle Buenaobra | students | BASE TABLE | InnoDB | 10 | Dynamic | 5 | 3276 | 16384 | 0 | 0 | 0 | NULL | 2024-09-24 03:40:28 | 2024-09-24 03:40:28 | NULL | utf8mb4_0900_ai_ci | NULL | |||
def | STUDENTDB | STUDENTDB | BASE TABLE | InnoDB | 10 | Dynamic | 1 | 16384 | 16384 | 0 | 0 | 0 | NULL | 2024-09-24 03:38:44 | 2024-09-24 03:40:53 | NULL | utf8mb4_0900_ai_ci | NULL | |||
def | information_schema | CHARACTER_SETS | SYSTEM VIEW | NULL | 10 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | CHECK_CONSTRAINTS | SYSTEM VIEW | NULL | 10 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | COLLATIONS | SYSTEM VIEW | NULL | 10 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | COLLATION_CHARACTER_SET_APPLICABILITY | SYSTEM VIEW | NULL | 10 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | COLUMNS | SYSTEM VIEW | NULL | 10 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | COLUMN_PRIVILEGES | SYSTEM VIEW | NULL | 10 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | COLUMN_STATISTICS | SYSTEM VIEW | NULL | 10 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | ENGINES | SYSTEM VIEW | NULL | 10 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | EVENTS | SYSTEM VIEW | NULL | 10 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | FILES | SYSTEM VIEW | NULL | 10 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | INNODB_BUFFER_PAGE | SYSTEM VIEW | NULL | 10 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-10-30 15:09:34 | NULL | NULL | NULL | NULL | |||
def | information_schema | INNODB_BUFFER_PAGE_LRU | SYSTEM VIEW | NULL | 10 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-10-30 15:09:34 | NULL | NULL | NULL | NULL | |||
def | information_schema | INNODB_BUFFER_POOL_STATS | SYSTEM VIEW | NULL | 10 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-10-30 15:09:34 | NULL | NULL | NULL | NULL | |||
def | information_schema | INNODB_CACHED_INDEXES | SYSTEM VIEW | NULL | 10 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-10-30 15:09:34 | NULL | NULL | NULL | NULL | |||
def | information_schema | INNODB_CMP | SYSTEM VIEW | NULL | 10 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-10-30 15:09:34 | NULL | NULL | NULL | NULL | |||
def | information_schema | INNODB_CMPMEM | SYSTEM VIEW | NULL | 10 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-10-30 15:09:34 | NULL | NULL | NULL | NULL | |||
def | information_schema | INNODB_CMPMEM_RESET | SYSTEM VIEW | NULL | 10 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-10-30 15:09:34 | NULL | NULL | NULL | NULL | |||
def | information_schema | INNODB_CMP_PER_INDEX | SYSTEM VIEW | NULL | 10 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-10-30 15:09:34 | NULL | NULL | NULL | NULL | |||
def | information_schema | INNODB_CMP_PER_INDEX_RESET | SYSTEM VIEW | NULL | 10 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-10-30 15:09:34 | NULL | NULL | NULL | NULL | |||
def | information_schema | INNODB_CMP_RESET | SYSTEM VIEW | NULL | 10 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-10-30 15:09:34 | NULL | NULL | NULL | NULL | |||
def | information_schema | INNODB_COLUMNS | SYSTEM VIEW | NULL | 10 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-10-30 15:09:34 | NULL | NULL | NULL | NULL | |||
def | information_schema | INNODB_DATAFILES | SYSTEM VIEW | NULL | 10 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL | |||
def | information_schema | INNODB_FIELDS | SYSTEM VIEW | NULL | 10 | NULL | 0 | 0 | 0 | 0 | 0 | 0 | NULL | 2019-10-30 15:09:27 | NULL | NULL | NULL | NULL |
|