PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-indexes-table.html
Example mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_INDEXES WHERE TABLE_ID = 34\G *************************** 1. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-profiling-table.html
Note This table is deprecated; expect it to be removed in a future MySQL release. Its contents correspond to the information produced by the SHOW PROFILE and SHOW PROFILES statements (see Section 15.7.7.30, “SHOW PROFILE Statement”). The table ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-role-column-grants-table.html
The ROLE_COLUMN_GRANTS table (available as of MySQL 8.0.19) provides information about the column privileges for roles that are available to or granted by the currently enabled roles. The ROLE_COLUMN_GRANTS table has these columns: GRANTOR The user ...
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 ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-role-table-grants-table.html
The ROLE_TABLE_GRANTS table (available as of MySQL 8.0.19) provides information about the table privileges for roles that are available to or granted by the currently enabled roles. The ROLE_TABLE_GRANTS table has these columns: GRANTOR The user ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-schema-privileges-table.html
The SCHEMA_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. TABLE_CATALOG The name of the catalog to which the schema belongs. The value can be any privilege ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-schemata-table.html
A schema is a database, so the SCHEMATA table provides information about databases. The SCHEMATA table has these columns: CATALOG_NAME The name of the catalog to which the schema belongs. The following statements are equivalent: SELECT SCHEMA_NAME ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-st-units-of-measure-table.html
The ST_UNITS_OF_MEASURE table (available as of MySQL 8.0.14) provides information about acceptable units for the ST_Distance() function. The ST_UNITS_OF_MEASURE table has these columns: UNIT_NAME The name of the unit.
https://dev.mysql.com/doc/refman/8.0/en/information-schema-table-constraints-extensions-table.html
The TABLE_CONSTRAINTS_EXTENSIONS table (available as of MySQL 8.0.21) provides information about table constraint attributes defined for primary and secondary storage engines. The TABLE_CONSTRAINTS_EXTENSIONS table has these columns: ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-table-privileges-table.html
The TABLE_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. TABLE_CATALOG The name of the catalog to which the table belongs. TABLE_SCHEMA The name of the schema ...