PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/keyring-okv-plugin.html
Note The keyring_okv plugin is an extension included in MySQL Enterprise Edition, a commercial product. Important The keyring_okv keyring plugin is deprecated, and is being replaced by the Key Management Interoperability Protocol (KMIP) Keyring ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/en/multiple-windows-servers.html
The following sections describe how to start each server with different values for those options that must be unique per server, such as the data directory. You can run multiple servers on Windows by starting them manually from the command line, ...
https://dev.mysql.com/doc/refman/9.7/en/multiple-windows-services.html
To set up multiple MySQL services, you must make sure that each instance uses a different service name in addition to the other parameters that must be unique per instance. On Windows, a MySQL server can run as a Windows service. The procedures for ...
https://dev.mysql.com/doc/refman/9.7/en/myisam-repair.html
The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and .MYD). You can also use the CHECK TABLE and REPAIR TABLE statements to check and repair MyISAM tables. See Section 15.7.3.2, “CHECK TABLE ...
https://dev.mysql.com/doc/refman/9.7/en/myisam-storage-engine.html
MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful extensions. Table 18.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather ...