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-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 28.1 INFORMATION_SCHEMA Tables Table Name Description Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable ...
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-view-table-usage-table.html
The VIEW_TABLE_USAGE table (available as of MySQL 8.0.13) provides access to information about tables and views used in view definitions. You can see information only for views for which you have some privilege, and only for tables for which you ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-data-locks-table.html
In practice, InnoDB always creates an index (GEN_CLUST_INDEX), so INDEX_NAME is non-NULL for InnoDB tables. For information about which lock requests are blocked by which held locks, see Section 29.12.13.2, “The data_lock_waits Table”. row ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-fulltext-index.html
A full-text index is defined as part of a CREATE TABLE statement or added to an existing table using ALTER TABLE or CREATE INDEX. The inverted index is partitioned into six auxiliary index tables to support parallel index creation. Consider ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-table-options.html
The replica checks for and evaluates table options only if either of the following two conditions is true: No matching database options were found. When viewed in terms of events, the process of checking table options is the same for both row-based ...One or more database options were found, and were evaluated to arrive at an “execute” condition according to the rules described in the previous section (see Section 19.2.5.1, “Evaluation of Database-Level Replication and Binary Logging ...
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-table-constraints-table.html
The TABLE_CONSTRAINTS table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint belongs. TABLE_SCHEMA The name of the schema (database) to which the table belongs. CONSTRAINT_SCHEMA The name of the schema (database) ...
https://dev.mysql.com/doc/refman/8.0/en/with.html
CTEs are similar to tables created with CREATE [TEMPORARY] TABLE but need not be defined or dropped explicitly. A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-threads-table.html
If the thread spawns a subthread, matching occurs again for the threads table row created for the subthread. If the thread spawns a subthread, matching occurs again for the threads table row created for the subthread. The threads table contains a ...Each row contains information about a thread and indicates whether monitoring and historical event logging are enabled for it: mysql> SELECT * FROM performance_schema.threads\G *************************** ...