10bet网址
MySQL 8.0参考手册
相关文件10bet官方网站 本手册下载 从本手册中摘录

MySQL 8.0参考手册/ Information_schema表

第26章信息模式表

目录

26.1介绍
26.2 Information_schema Administrable_Role_Authorizations表
26.3 Information_schema适用_ROLES表
26.4 INFORMATION_SCHEMA CHARACTER_SETS表
26.5 Information_schema check_constraints表
26.6 INFORMATION_SCHEMA排序表
26.7 INFORMATION_SCHEMA collation_character_set_适用性表
26.8 INFORMATION_SCHEMA列表
26.9 Information_schema columns_extensions表
26.10 INFORMATION_SCHEMA COLUMN_PRIVILEGES表
26.11 INFORMATION_SCHEMA COLUMN_STATISTICS表
26.12 INFORMATION_SCHEMA ENABLED_ROLES表
26.13 Information_Schema引擎表
26.14 INFORMATION_SCHEMA EVENTS表
26.15 Information_schema文件表
26.16信息_schema key_column_usage表
26.17 Information_schema ndb_transid_mysql_connection_map表
26.18 Information_schema关键字表
26.19 INFORMATION_SCHEMA OPTIMIZER_TRACE表
26.20信息_Schema参数表
26.21 Information_schema Partitions表
26.22信息模式插件表
26.23 Information_schema processlist表
26.24 Information_schema分析表
26.25 Information_schema引用_constraints表
26.26 Information_schema Resource_Groups表
26.27 The INFORMATION_SCHEMA role_column_grant Table
26.28 Information_schema角色_routine_grants表
26.29 Information_schema role_table_grants表
26.30 Information_schema例程表
26.31 INFORMATION_SCHEMA schema表
26.32 INFORMATION_SCHEMA SCHEMATA_EXTENSIONS表
26.33 INFORMATION_SCHEMA SCHEMA_PRIVILEGES表
26.34 INFORMATION_SCHEMA统计表
26.35 Information_schema st_geometry_columns表
26.36 Information_schema st_spatial_reference_systems表
26.37 Information_schema st_units_of_measure表
26.38 Information_schema表表
26.39 INFORMATION_SCHEMA TABLES_EXTENSIONS表
26.40 The INFORMATION_SCHEMA TABLESPACES表
26.41 INFORMATION_SCHEMA TABLESPACES_EXTENSIONS表
26.42 Information_schema table_constraints表
26.43 Information_schema table_constraints_extensions表
26.44 INFORMATION_SCHEMA TABLE_PRIVILEGES表信息
26.45 INFORMATION_SCHEMA触发表
26.46 Information_schema user_attributes表
26.47 Information_schema user_privileges表
26.48查看INFORMATION_SCHEMA表
26.49 INFORMATION_SCHEMA VIEW_ROUTINE_USAGE表
26.50 INFORMATION_SCHEMA VIEW_TABLE_USAGE表
26.51 Information_schema InnoDB表
26.51.1 Information_schema Innodb_buffer_page表
26.51.2 Information_schema Innodb_buffer_page_lru表
26.51.3信息_schemaInnodb_buffer_Pool_Stats表
26.51.4 INFORMATION_SCHEMA innodb_cache_indexes表
26.51.5 Information_schema Innodb_cmp和Innodb_cmp_reset表
26.51.6 Information_schema Innodb_cmpmem和Innodb_cmpmem_reset表
26.51.7 INNODB_CMP_PER_INDEX和INNODB_CMP_PER_INDEX_RESET表信息
26.51.8 INNODB_COLUMNS表信息
26.51.9 INNODB_DATAFILES表信息
26.51.10 Information_schema Innodb_fields表
26.51.11 Information_schema Innodb_fuleign表
26.51.12 INFORMATION_SCHEMA INNODB_FOREIGN_COLS表
26.51.13信息_schema innodb_ft_being_deleted表
26.51.14信息_schemaInnodb_ft_config表
26.51.15 INNODB_FT_DEFAULT_STOPWORD表信息
26.51.16 INNODB_FT_DELETED表信息
26.51.17 The INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE表
26.51.18 The INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE表
26.51.19 INFORMATION_SCHEMA INNODB_INDEXES表
26.51.20 INNODB_LOCKS表信息
26.51.21 INNODB_LOCK_WAITS表信息
26.51.22 Information_schema Innodb_metrics表
26.51.23信息_schema innodb_session_temp_tablespaces表
26.51.24信息schema INNODB_TABLES表
26.51.25 Information_schema Innodb_TableSpaces表
26.51.26 INNODB_TABLESPACES_BRIEF表信息
26.51.27 Information_schema Innodb_TableStats视图
26.51.28信息_schema innodb_temp_table_info表
26.51.29 INNODB_TRX表信息
26.51.30 Information_schema Innodb_virtual表
26.52 Information_schema线程池表
26.52.1信息_schema tp_thread_group_state表
26.52.2信息_schema tp_thread_group_stats表
26.52.3 Information_schema tp_thread_state表
26.53 Information_schema连接控制表
26.53.1 INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS表
26.54 Information_schema MySQL Enterprise防火墙表
26.54.1信息_schema mysql_firewall_users表
26.54.2信息_schema mysql_firewall_whitelist表
26.55 SHOW语句扩展名

Information_Schema.提供对数据库的访问元数据,有关MySQL Server的信息,例如数据库或表的名称,列的数据类型或访问权限。有时用于此信息的其他术语数据词典系统目录