PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/general-information-schema-tables.html
The following sections describe what may be denoted as the “general” set of INFORMATION_SCHEMA tables. These are the tables not associated with particular storage engines, components, or plugins.
https://dev.mysql.com/doc/refman/8.0/en/information-schema-administrable-role-authorizations-table.html
The ADMINISTRABLE_ROLE_AUTHORIZATIONS table (available as of MySQL 8.0.19) provides information about which roles applicable for the current user or role can be granted to other users or roles. The ADMINISTRABLE_ROLE_AUTHORIZATIONS table has these ...GRANTEE The user name part of the account to which the role is ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-applicable-roles-table.html
The APPLICABLE_ROLES table (available as of MySQL 8.0.19) provides information about the roles that are applicable for the current user. The APPLICABLE_ROLES table has these columns: USER The user name part of the current user account. IS_GRANTABLE ...GRANTEE The user name part of the account to which the role is ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-character-sets-table.html
The CHARACTER_SETS table has these columns: CHARACTER_SET_NAME The character set name. MAXLEN The maximum number of bytes required to store one character. Notes Character set information is also available from the SHOW CHARACTER SET statement. The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-collation-character-set-applicability-table.html
The COLLATION_CHARACTER_SET_APPLICABILITY table indicates what character set is applicable for what collation. CHARACTER_SET_NAME The name of the character set with which the collation is associated. Notes The COLLATION_CHARACTER_SET_APPLICABILITY ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-collations-table.html
The COLLATIONS table provides information about collations for each character set. CHARACTER_SET_NAME The name of the character set with which the collation is associated. IS_DEFAULT Whether the collation is the default for its character set.
https://dev.mysql.com/doc/refman/8.0/en/information-schema-enabled-roles-table.html
The ENABLED_ROLES table (available as of MySQL 8.0.19) provides information about the roles that are enabled within the current session. The ENABLED_ROLES table has these columns: ROLE_NAME The user name part of the granted role. IS_DEFAULT YES or ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimizer-trace-table.html
The OPTIMIZER_TRACE table provides information produced by the optimizer tracing capability for traced statements. The OPTIMIZER_TRACE table has these columns: QUERY The text of the traced statement. MISSING_BYTES_BEYOND_MAX_MEM_SIZE Each ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-resource-groups-table.html
The RESOURCE_GROUPS table provides access to information about resource groups. The RESOURCE_GROUPS table has these columns: RESOURCE_GROUP_NAME The name of the resource group. For general discussion of the resource group capability, see Section ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-role-routine-grants-table.html
The ROLE_ROUTINE_GRANTS table (available as of MySQL 8.0.19) provides information about the routine privileges for roles that are available to or granted by the currently enabled roles. The ROLE_ROUTINE_GRANTS table has these columns: GRANTOR The ...GRANTOR_HOST The host name part of the account that granted the ...