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/partitioning-key.html
PARTITION BY KEY are similar to those for creating a table that is partitioned by hash. In both of these cases, the partitioning key is the id column, even though it is not shown in the output of SHOW CREATE TABLE or in the PARTITION_EXPRESSION ...
https://dev.mysql.com/doc/refman/8.0/en/stored-program-restrictions.html
(Bug #16396) References to stored functions, loadable functions, and tables in the ON SCHEDULE clauses of CREATE EVENT and ALTER EVENT statements are not supported. Any stored routine or trigger that interacts with MySQL Cluster tables must be ...
https://dev.mysql.com/doc/refman/8.0/en/cannot-find-table.html
Even for file systems that are not case-sensitive, such as on Windows, all references to a given table within a query must use the same lettercase. You can check which tables are in the default database with SHOW TABLES.
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-foreign-cols-table.html
The INNODB_FOREIGN_COLS table provides status information about InnoDB foreign key columns. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_FOREIGN_COLS table has ...
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 ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-metrics-table.html
The INNODB_METRICS table provides a wide variety of InnoDB performance information, complementing the specific focus areas of the Performance Schema tables for InnoDB. The INNODB_METRICS table has these columns: NAME A unique name for the counter.
https://dev.mysql.com/doc/refman/8.0/en/information-schema-st-geometry-columns-table.html
The ST_GEOMETRY_COLUMNS table provides information about table columns that store spatial data. This table is based on the SQL/MM (ISO/IEC 13249-3) standard, with extensions as noted. MySQL implements ST_GEOMETRY_COLUMNS as a view on the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-firewall-group-allowlist-table.html
The firewall_group_allowlist table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It is used in conjunction with the mysql.firewall_group_allowlist system table that provides persistent storage of firewall data; see ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-firewall-groups-table.html
The firewall_groups table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It is used in conjunction with the mysql.firewall_groups system table that provides persistent storage of firewall data; see MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-firewall-membership-table.html
The firewall_membership table provides a view into the in-memory data cache for MySQL Enterprise Firewall. It is used in conjunction with the mysql.firewall_membership system table that provides persistent storage of firewall data; see MySQL ...