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/innodb-truncate-table-reclaim-space.html
Additionally, there cannot be a foreign key constraint between the table being truncated and other tables, otherwise the TRUNCATE TABLE operation fails. A foreign key constraint between two columns in the same table, however, is permitted. To ...
https://dev.mysql.com/doc/refman/8.0/en/join.html
index_hint: { USE {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] ([index_list]) | {IGNORE|FORCE} {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] (index_list) } index_list: index_name [, index_name] ... MySQL supports the following JOIN syntax for the ...
https://dev.mysql.com/doc/refman/8.0/en/multifactor-authentication.html
MFA enables additional authentication methods, such as authentication using multiple passwords, or authentication using devices like smart cards, security keys, and biometric readers. Something you have, such as a security key or smart card.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-database-objects.html
Some database objects such as tables and indexes have different limitations when using the NDBCLUSTER storage engine: Number of database objects. The maximum number of all NDB database objects in a single NDB Cluster—including databases, tables, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-enterprise-encryption.html
These functions enable Enterprise applications to perform the following operations: Implement added data protection using public-key asymmetric cryptography Create public and private keys and digital signatures Perform asymmetric encryption and ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-installer-setup.html
The following figure identifies and describes the key areas of this step. Template files contain keys and formulas to calculate some values dynamically. Choosing a Setup Type Path Conflicts Check Requirements MySQL Installer Configuration Files ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns-list.html
This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types other than integer types to be used as partitioning columns; you can use string types, DATE, and DATETIME columns. In ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-list.html
ADD PARTITION statement to restore the table's original partitioning scheme.) As with RANGE partitioning, it is possible to combine LIST partitioning with partitioning by hash or key to produce a composite partitioning (subpartitioning). You can ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-storage-common-layer.html
From a technical perspective, what are some of the unique supporting infrastructure components that are in a storage engine? Some of the key feature differentiations include: Concurrency: Some applications have more granular lock requirements (such ... A MySQL pluggable storage engine is the component in the MySQL database server that is responsible for performing the actual data I/O operations for a database as well as enabling and enforcing certain feature sets that target a specific application ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-examples.html
This section provides some examples that show precision math query results in MySQL. These examples demonstrate the principles described in Section 14.24.3, “Expression Handling”, and Section 14.24.4, “Rounding Behavior”. Consider the ...