PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-check-constraints-table.html
As of MySQL 8.0.16, CREATE TABLE permits the core features of table and column CHECK constraints, and the CHECK_CONSTRAINTS table provides information about these constraints. The CHECK_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-column-privileges-table.html
The COLUMN_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 containing the column belongs. TABLE_SCHEMA ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-columns-extensions-table.html
The COLUMNS_EXTENSIONS table (available as of MySQL 8.0.21) provides information about column attributes defined for primary and secondary storage engines. The COLUMNS_EXTENSIONS table has these columns: TABLE_CATALOG The name of the catalog to ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-columns-table.html
on update CURRENT_TIMESTAMP for TIMESTAMP or DATETIME columns that have the ON UPDATE CURRENT_TIMESTAMP attribute. The related ST_GEOMETRY_COLUMNS table provides information about table columns that store spatial data. The COLUMNS table has these ...
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-engines-table.html
This is particularly useful for checking whether a storage engine is supported, or to see what the default engine is. The ENGINES table has these columns: ENGINE The name of the storage engine. SUPPORT The server's level of support for the storage ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 28.2 INFORMATION_SCHEMA General Tables Table Name Description Introduced Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-fields-table.html
Example mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_FIELDS WHERE INDEX_ID = 117\G *************************** 1. The INNODB_FIELDS table provides metadata about the key columns (fields) of InnoDB indexes. For related usage information and ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-foreign-cols-table.html
Example mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_FOREIGN_COLS WHERE ID = 'test/fk1'\G *************************** 1. The INNODB_FOREIGN_COLS table provides status information about InnoDB foreign key columns. For related usage information and ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-foreign-table.html
For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_FOREIGN table has these columns: ID The name (not a numeric value) of the foreign key index, preceded by the schema ...