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/boolean-literals.html
The constants TRUE and FALSE evaluate to 1 and 0, respectively. mysql> SELECT TRUE, true, FALSE, false; -> 1, 1, 0, 0 .
https://dev.mysql.com/doc/refman/9.7/en/exists-and-not-exists-subqueries.html
If a subquery returns any rows at all, EXISTS subquery is TRUE, and NOT EXISTS subquery is FALSE. For example: SELECT column1 FROM t1 WHERE EXISTS (SELECT * FROM t2); Traditionally, an EXISTS subquery starts with SELECT *, but it could begin with ...
https://dev.mysql.com/doc/refman/9.7/en/explain.html
In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a query). The following discussion uses ...
https://dev.mysql.com/doc/refman/9.7/en/json-creation-functions.html
The functions listed in this section compose JSON values from component elements. JSON_ARRAY([val[, val] ...]) Evaluates a (possibly empty) list of values and returns a JSON array containing those values. mysql> SELECT JSON_ARRAY(1, "abc", NULL, ...
https://dev.mysql.com/doc/refman/9.7/en/json-function-reference.html
Table 14.22 JSON Functions Name Description Deprecated -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). ->> Return value from JSON column after evaluating path and unquoting the result; equivalent to ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-component-installation.html
Keyring service consumers require that a keyring component or plugin be installed: To use a keyring component, begin with the instructions here. To use a keyring plugin instead, begin with Section 8.4.5.3, “Keyring Plugin Installation”. If you ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-okv-component.html
Note component_keyring_kmip is an extension included in MySQL Enterprise Edition, a commercial product. The Key Management Interoperability Protocol (KMIP) Keyring component is intended to replace the keyring_okv Keyring plugin, which is now ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-params-other.html
The listings in this section provide information about parameters used in the [computer], [tcp], and [shm] sections of a config.ini file for configuring NDB Cluster. For detailed descriptions and additional information about individual parameters, ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-ps-tables.html
NDB provides information in the MySQL Performance Schema about ndbcluster plugin threads and instrumenting for transaction batch memory. These features are described in greater detail in the sections which follow. Thread names are shown in the name ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-rolling-restart.html
This section discusses how to perform a rolling restart of an NDB Cluster installation, so called because it involves stopping and starting (or restarting) each node in turn, so that the cluster itself remains operational. This is often done as ...