Skip to Main Content
The world's most popular open source database
Contact MySQL
|
Login
|
Register
MySQL.com
Downloads
Documentation
Developer Zone
Developer Zone
Downloads
MySQL.com
Documentation
MySQL Server
MySQL Enterprise
Workbench
InnoDB Cluster
MySQL NDB Cluster
Connectors
More
MySQL.com
Downloads
Developer Zone
Section Menu:
Documentation Home
MySQL 8.3 Reference Manual
前言和法律声明
一般信息
安装 MySQL
升级 MySQL
降级 MySQL
教程
MySQL 程序
MySQL 服务器管理
安全性
备份和恢复
优化
语言结构
字符集、排序规则、Unicode
数据类型
函数和运算符
SQL 语句
MySQL 数据字典
InnoDB 存储引擎
替代存储引擎
复制
组复制
MySQL Shell
将 MySQL 用作文档存储
InnoDB 集群
InnoDB 副本集
MySQL NDB Cluster 8.3
分区
存储对象
INFORMATION_SCHEMA 表
简介
INFORMATION_SCHEMA 表参考
INFORMATION_SCHEMA 常规表
INFORMATION_SCHEMA 常规表参考
INFORMATION_SCHEMA ADMINISTRABLE_ROLE_AUTHORIZATIONS 表
INFORMATION_SCHEMA APPLICABLE_ROLES 表
INFORMATION_SCHEMA CHARACTER_SETS 表
INFORMATION_SCHEMA CHECK_CONSTRAINTS 表
INFORMATION_SCHEMA COLLATIONS 表
INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY 表
INFORMATION_SCHEMA COLUMNS 表
INFORMATION_SCHEMA COLUMNS_EXTENSIONS 表
INFORMATION_SCHEMA COLUMN_PRIVILEGES 表
INFORMATION_SCHEMA COLUMN_STATISTICS 表
INFORMATION_SCHEMA ENABLED_ROLES 表
INFORMATION_SCHEMA ENGINES 表
INFORMATION_SCHEMA EVENTS 表
INFORMATION_SCHEMA FILES 表
INFORMATION_SCHEMA KEY_COLUMN_USAGE 表
INFORMATION_SCHEMA KEYWORDS 表
INFORMATION_SCHEMA ndb_transid_mysql_connection_map 表
INFORMATION_SCHEMA OPTIMIZER_TRACE 表
INFORMATION_SCHEMA PARAMETERS 表
INFORMATION_SCHEMA PARTITIONS 表
INFORMATION_SCHEMA PLUGINS 表
INFORMATION_SCHEMA PROCESSLIST 表
INFORMATION_SCHEMA PROFILING 表
INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS 表
INFORMATION_SCHEMA RESOURCE_GROUPS 表
INFORMATION_SCHEMA ROLE_COLUMN_GRANTS 表
INFORMATION_SCHEMA ROLE_ROUTINE_GRANTS 表
INFORMATION_SCHEMA ROLE_TABLE_GRANTS 表
INFORMATION_SCHEMA ROUTINES 表
INFORMATION_SCHEMA SCHEMATA 表
INFORMATION_SCHEMA SCHEMATA_EXTENSIONS 表
INFORMATION_SCHEMA SCHEMA_PRIVILEGES 表
INFORMATION_SCHEMA STATISTICS 表
INFORMATION_SCHEMA ST_GEOMETRY_COLUMNS 表
INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS 表
INFORMATION_SCHEMA ST_UNITS_OF_MEASURE 表
INFORMATION_SCHEMA TABLES 表
INFORMATION_SCHEMA TABLES_EXTENSIONS 表
INFORMATION_SCHEMA TABLESPACES 表
INFORMATION_SCHEMA TABLESPACES_EXTENSIONS 表
INFORMATION_SCHEMA TABLE_CONSTRAINTS 表
INFORMATION_SCHEMA TABLE_CONSTRAINTS_EXTENSIONS 表
INFORMATION_SCHEMA TABLE_PRIVILEGES 表
INFORMATION_SCHEMA TRIGGERS 表
INFORMATION_SCHEMA USER_ATTRIBUTES 表
INFORMATION_SCHEMA USER_PRIVILEGES 表
INFORMATION_SCHEMA VIEWS 表
INFORMATION_SCHEMA VIEW_ROUTINE_USAGE 表
INFORMATION_SCHEMA VIEW_TABLE_USAGE 表
INFORMATION_SCHEMA InnoDB 表
INFORMATION_SCHEMA InnoDB 表参考
INFORMATION_SCHEMA INNODB_BUFFER_PAGE 表
INFORMATION_SCHEMA INNODB_BUFFER_PAGE_LRU 表
INFORMATION_SCHEMA INNODB_BUFFER_POOL_STATS 表
INFORMATION_SCHEMA INNODB_CACHED_INDEXES 表
INFORMATION_SCHEMA INNODB_CMP and INNODB_CMP_RESET 表
INFORMATION_SCHEMA INNODB_CMPMEM and INNODB_CMPMEM_RESET 表
INFORMATION_SCHEMA INNODB_CMP_PER_INDEX and INNODB_CMP_PER_INDEX_RESET 表
INFORMATION_SCHEMA INNODB_COLUMNS 表
INFORMATION_SCHEMA INNODB_DATAFILES 表
INFORMATION_SCHEMA INNODB_FIELDS 表
INFORMATION_SCHEMA INNODB_FOREIGN 表
INFORMATION_SCHEMA INNODB_FOREIGN_COLS 表
INFORMATION_SCHEMA INNODB_FT_BEING_DELETED 表
INFORMATION_SCHEMA INNODB_FT_CONFIG 表
INFORMATION_SCHEMA INNODB_FT_DEFAULT_STOPWORD 表
INFORMATION_SCHEMA INNODB_FT_DELETED 表
INFORMATION_SCHEMA INNODB_FT_INDEX_CACHE 表
INFORMATION_SCHEMA INNODB_FT_INDEX_TABLE 表
INFORMATION_SCHEMA INNODB_INDEXES 表
INFORMATION_SCHEMA INNODB_METRICS 表
INFORMATION_SCHEMA INNODB_SESSION_TEMP_TABLESPACES 表
INFORMATION_SCHEMA INNODB_TABLES 表
INFORMATION_SCHEMA INNODB_TABLESPACES 表
INFORMATION_SCHEMA INNODB_TABLESPACES_BRIEF 表
INFORMATION_SCHEMA INNODB_TABLESTATS 视图
INFORMATION_SCHEMA INNODB_TEMP_TABLE_INFO 表
INFORMATION_SCHEMA INNODB_TRX 表
INFORMATION_SCHEMA INNODB_VIRTUAL 表
INFORMATION_SCHEMA 线程池表
INFORMATION_SCHEMA 线程池表参考
INFORMATION_SCHEMA TP_THREAD_GROUP_STATE 表
INFORMATION_SCHEMA TP_THREAD_GROUP_STATS 表
INFORMATION_SCHEMA TP_THREAD_STATE 表
INFORMATION_SCHEMA 连接控制表
INFORMATION_SCHEMA 连接控制表参考
INFORMATION_SCHEMA CONNECTION_CONTROL_FAILED_LOGIN_ATTEMPTS 表
INFORMATION_SCHEMA MySQL 企业防火墙表
INFORMATION_SCHEMA 防火墙表参考
INFORMATION_SCHEMA MYSQL_FIREWALL_USERS 表
INFORMATION_SCHEMA MYSQL_FIREWALL_WHITELIST 表
SHOW 语句的扩展
MySQL 性能模式
MySQL sys 模式
连接器和 API
MySQL 企业版
MySQL Workbench
OCI Marketplace 上的 MySQL
遥测
MySQL 8.3 常见问题解答
错误消息和常见问题
索引
MySQL 词汇表
Related Documentation
MySQL 8.3 Release Notes
Download this Manual
PDF (US Ltr)
- 40.8Mb
PDF (A4)
- 40.9Mb
Man Pages (TGZ)
- 294.0Kb
Man Pages (Zip)
- 409.0Kb
Info (Gzip)
- 4.0Mb
Info (Zip)
- 4.0Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL NDB Cluster 8.3
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and macOS
MySQL Partitioning
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
MySQL Restrictions and Limitations
Security in MySQL
MySQL and Solaris
Building MySQL from Source
Starting and Stopping MySQL
MySQL Tutorial
MySQL and Windows
version 8.3
8.0 current
5.7
8.0 Japanese
MySQL 8.3 Reference Manual
/
INFORMATION_SCHEMA Tables
/ INFORMATION_SCHEMA Connection-Control Tables
28.6 INFORMATION_SCHEMA 连接控制表
28.6.1 INFORMATION_SCHEMA 连接控制表参考
28.6.2 INFORMATION_SCHEMA 连接控制失败登录尝试表
以下部分描述了与
CONNECTION_CONTROL
插件关联的
INFORMATION_SCHEMA
表。
PREV
HOME
UP
NEXT
Related Documentation
MySQL 8.3 Release Notes
Download this Manual
PDF (US Ltr)
- 40.8Mb
PDF (A4)
- 40.9Mb
Man Pages (TGZ)
- 294.0Kb
Man Pages (Zip)
- 409.0Kb
Info (Gzip)
- 4.0Mb
Info (Zip)
- 4.0Mb
Excerpts from this Manual
MySQL Backup and Recovery
MySQL NDB Cluster 8.3
MySQL Globalization
MySQL Information Schema
MySQL Installation Guide
MySQL and Linux/Unix
MySQL and macOS
MySQL Partitioning
MySQL Performance Schema
MySQL Replication
Using the MySQL Yum Repository
MySQL Restrictions and Limitations
Security in MySQL
MySQL and Solaris
Building MySQL from Source
Starting and Stopping MySQL
MySQL Tutorial
MySQL and Windows