SELECT * FROM `TABLES` ORDER BY `TABLE_SCHEMA` DESC
过滤行: |
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 | MAX_INDEX_LENGTH | TEMPORARY | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
def | phpmyadmin | pma__bookmark | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | 1 | 2025-02-27 02:24:33 | NULL | NULL | utf8_bin | NULL | Bookmarks | 0 | N | ||
def | phpmyadmin | pma__tracking | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2025-02-27 02:24:33 | NULL | NULL | utf8_bin | NULL | Database changes tracking for phpMyAdmin | 0 | N | ||
def | phpmyadmin | pma__column_info | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | 1 | 2025-02-27 02:24:33 | NULL | NULL | utf8_bin | NULL | Column information for phpMyAdmin | 0 | N | ||
def | phpmyadmin | pma__savedsearches | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | 1 | 2025-02-27 02:24:33 | NULL | NULL | utf8_bin | NULL | Saved searches | 0 | N | ||
def | phpmyadmin | pma__navigationhiding | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2025-02-27 02:24:33 | NULL | NULL | utf8_bin | NULL | Hidden items of navigation tree | 0 | N | ||
def | phpmyadmin | pma__userconfig | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2025-02-27 02:24:33 | 2025-08-29 15:07:49 | NULL | utf8_bin | NULL | User preferences storage for phpMyAdmin | 0 | N | ||
def | phpmyadmin | pma__designer_settings | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2025-02-27 02:24:33 | NULL | NULL | utf8_bin | NULL | Settings related to Designer | 0 | N | ||
def | phpmyadmin | pma__table_coords | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2025-02-27 02:24:33 | NULL | NULL | utf8_bin | NULL | Table coordinates for phpMyAdmin PDF output | 0 | N | ||
def | phpmyadmin | pma__pdf_pages | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | 1 | 2025-02-27 02:24:33 | NULL | NULL | utf8_bin | NULL | PDF relation pages for phpMyAdmin | 0 | N | ||
def | phpmyadmin | pma__usergroups | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2025-02-27 02:24:33 | NULL | NULL | utf8_bin | NULL | User groups with configured menu items | 0 | N | ||
def | phpmyadmin | pma__export_templates | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | 1 | 2025-02-27 02:24:33 | NULL | NULL | utf8_bin | NULL | Saved export templates | 0 | N | ||
def | phpmyadmin | pma__table_info | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2025-02-27 02:24:33 | NULL | NULL | utf8_bin | NULL | Table information for phpMyAdmin | 0 | N | ||
def | phpmyadmin | pma__recent | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2025-02-27 02:24:33 | 2025-08-29 23:49:51 | NULL | utf8_bin | NULL | Recently accessed tables | 0 | N | ||
def | phpmyadmin | pma__users | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2025-02-27 02:24:33 | NULL | NULL | utf8_bin | NULL | Users and their assignments to user groups | 0 | N | ||
def | phpmyadmin | pma__favorite | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2025-02-27 02:24:33 | NULL | NULL | utf8_bin | NULL | Favorite tables | 0 | N | ||
def | phpmyadmin | pma__table_uiprefs | BASE TABLE | InnoDB | 10 | Compact | 76 | 215 | 16384 | 0 | 0 | 0 | NULL | 2025-02-27 02:24:33 | NULL | NULL | utf8_bin | NULL | Tables' UI preferences | 0 | N | ||
def | phpmyadmin | pma__central_columns | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 0 | 0 | NULL | 2025-02-27 02:24:33 | NULL | NULL | utf8_bin | NULL | Central list of columns | 0 | N | ||
def | phpmyadmin | pma__relation | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | NULL | 2025-02-27 02:24:33 | NULL | NULL | utf8_bin | NULL | Relation table | 0 | N | ||
def | phpmyadmin | pma__history | BASE TABLE | InnoDB | 10 | Compact | 0 | 0 | 16384 | 0 | 16384 | 0 | 1 | 2025-02-27 02:24:33 | NULL | NULL | utf8_bin | NULL | SQL history for phpMyAdmin | 0 | N | ||
def | performance_schema | accounts | BASE TABLE | PERFORMANCE_SCHEMA | 10 | Fixed | 1000 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | 0 | N | |||
def | performance_schema | events_stages_summary_global_by_event_name | BASE TABLE | PERFORMANCE_SCHEMA | 10 | Dynamic | 1000 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | 0 | N | |||
def | performance_schema | events_stages_summary_by_account_by_event_name | BASE TABLE | PERFORMANCE_SCHEMA | 10 | Dynamic | 1000 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | 0 | N | |||
def | performance_schema | cond_instances | BASE TABLE | PERFORMANCE_SCHEMA | 10 | Dynamic | 1000 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | 0 | N | |||
def | performance_schema | events_statements_current | BASE TABLE | PERFORMANCE_SCHEMA | 10 | Dynamic | 1000 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | 0 | N | |||
def | performance_schema | events_stages_summary_by_host_by_event_name | BASE TABLE | PERFORMANCE_SCHEMA | 10 | Dynamic | 1000 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | utf8_general_ci | NULL | 0 | N |
过滤行: |