PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-undo-tablespaces.html
Unique undo tablespace file names are recommended to avoid potential file name conflicts when moving or cloning data. Undo tablespaces contain undo logs, which are collections of records containing information about how to undo the latest change by ...
https://dev.mysql.com/doc/refman/8.0/en/insert-select.html
To avoid ambiguous column reference problems when the SELECT and the INSERT refer to the same table, provide a unique alias for each table used in the SELECT part, and qualify column names in that part with the appropriate alias. INSERT ...
https://dev.mysql.com/doc/refman/8.0/en/installing-source-distribution.html
The first strategy places all build directories at the same level, which requires that you choose a unique name for each. To install MySQL from a standard source distribution: Verify that your system satisfies the tool requirements listed at ...
https://dev.mysql.com/doc/refman/8.0/en/intersect.html
query_expression_body INTERSECT [ALL | DISTINCT] query_expression_body [INTERSECT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” INTERSECT limits the ...
https://dev.mysql.com/doc/refman/8.0/en/json.html
JSON_MERGE_PRESERVE() handles multiple objects having the same key by combining all unique values for that key in an array; this array is then used as the value for that key in the result. The JSON data type provides these advantages over storing ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-okv-plugin.html
Note The keyring_okv plugin is an extension included in MySQL Enterprise Edition, a commercial product. The Key Management Interoperability Protocol (KMIP) enables communication of cryptographic keys between a key management server and its clients.
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.0/en/ldml-collation-example.html
To add a UCA collation for a Unicode character set without recompiling MySQL, use the following procedure. If you are unfamiliar with the LDML rules used to describe the collation's sort characteristics, see Section 12.14.4.2, “LDML Syntax ...
https://dev.mysql.com/doc/refman/8.0/en/locking-functions.html
Uniquely named locks acquired with GET_LOCK() appear in the Performance Schema metadata_locks table. While held by one session, other sessions cannot obtain a lock of the same name. Returns 1 if the lock was obtained successfully, 0 if the attempt ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-column-indexes.html
If this column is short, reasonably unique, and indexed, it might be faster than a “wide” index on many columns. MySQL can create composite indexes (that is, indexes on multiple columns). For certain data types, you can index a prefix of the ...