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/create-spatial-reference-system.html
srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' IDENTIFIED BY org_id | DESCRIPTION 'description' } srid, org_id: 32-bit unsigned integer This statement creates a spatial reference system (SRS) definition and ...
https://dev.mysql.com/doc/refman/9.7/en/json-utility-functions.html
This section documents utility functions that act on JSON values, or strings that can be parsed as JSON values. JSON_PRETTY() prints out a JSON value in a format that is easy to read. JSON_STORAGE_SIZE() and JSON_STORAGE_FREE() show, respectively, ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-encrypted-file-component.html
It contains the path to the file where the server stores keys: { "path": "/usr/local/mysql/keyring/component_keyring_encrypted_file.keys", "password": "password", "read_only": false } After adding the two files, restart mysqld. If the item is ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-file-component.html
It contains the path to the file where the server stores keys: { "path": "/usr/local/mysql/keyring/component_keyring_file.keys", "read_only": false } After adding the two files, restart mysqld. If the item is present, its value is true or false, ...
https://dev.mysql.com/doc/refman/9.7/en/nested-join-optimization.html
The following discussion refers to the join syntax described in Section 15.2.13.2, “JOIN Clause”. The syntax of table_factor is extended in comparison with the SQL Standard. The latter accepts only table_reference, not a list of them inside a ...
https://dev.mysql.com/doc/refman/9.7/en/subquery-optimization-with-exists.html
Another instance where the optimizer notices that NULL and FALSE subquery results need not be distinguished is this construct: ... WHERE outer_expr IN (subquery) In this case, the WHERE clause rejects the row whether IN (subquery) returns NULL or ...
https://dev.mysql.com/doc/refman/9.7/en/explain-output.html
Impossible HAVING (JSON property: message) The HAVING clause is always false and cannot select any rows. Impossible WHERE (JSON property: message) The WHERE clause is always false and cannot select any rows. Impossible WHERE noticed after reading ...
https://dev.mysql.com/doc/refman/9.7/en/json-validation-functions.html
JSON_SCHEMA_VALID() returns true if the document validates against the schema, and false if it does not; JSON_SCHEMA_VALIDATION_REPORT() provides a report in JSON format on the validation. Provided that these conditions are met: If the document ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-aws-component.html
Note component_keyring_aws is an extension included in MySQL Enterprise Edition, a commercial product. The AWS Keyring component is intended to replace the AWS Keyring plugin, which is now deprecated. The component_keyring_aws keyring component ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-api-definition.html
AutoReconnect Version (or later) NDB 9.7.0 Type or units boolean Default false Range true, false Restart Type Node Restart: Requires a rolling restart of the cluster. Wan Version (or later) NDB 9.7.0 Type or units boolean Default false Range true, ... The [mysqld] and [api] sections in the config.ini file define the behavior of the MySQL servers (SQL nodes) and other applications (API nodes) used to access cluster ...