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/semijoins-antijoins.html
IN (SELECT ...)) IS NOT TRUE can be transformed into antijoins. The subquery can also be the argument to an expression modified by NOT, IS [NOT] TRUE, or IS [NOT] FALSE. A semijoin is a preparation-time transformation that enables multiple ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-filtering.html
To assign a filter explicitly to a particular user account or accounts, define the filter, then assign it to the relevant accounts: SELECT audit_log_filter_set_filter('log_all', '{ "filter": { "log": true } }'); SELECT ... Note For audit log ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-filtering.html
To assign a filter explicitly to a particular user account or accounts, define the filter, then assign it to the relevant accounts: SELECT audit_log_filter_set_filter('log_all', '{ "filter": { "log": true } }'); SELECT ... Important The audit_log ...
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 the preceding example, if t2 contains any rows, even rows with nothing but NULL values, the EXISTS condition is TRUE. For example: SELECT column1 ...
https://dev.mysql.com/doc/refman/9.7/en/explain.html
This is true regardless of the current value of the explain_format system variable. 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, ...
https://dev.mysql.com/doc/refman/9.7/en/json-creation-functions.html
mysql> SELECT JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()); +---------------------------------------------+ | JSON_ARRAY(1, "abc", NULL, TRUE, CURTIME()) | +---------------------------------------------+ | [1, "abc", null, true, "11:30:24.000000"] | ... The functions listed in this section compose JSON values from component ...
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
If the item is present, its value is true or false, indicating whether the server should read component-loading information from the local manifest file. If the value is true, the server ignores the other items in the global manifest file and ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-hashicorp-plugin.html
listener "tcp" { address="127.0.0.1:8200" tls_cert_file="/home/username/certificates/vault.crt" tls_key_file="/home/username/certificates/vault.key" } storage "file" { path = "/home/username/vaultstorage/storage" } ui = true Start the HashiCorp ...