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
Cells in arrays are represented by [N], where N is a non-negative integer. BLOB BIT OPAQUE DATETIME TIME DATE BOOLEAN ARRAY OBJECT STRING INTEGER, DOUBLE NULL For JSON values of the same precedence, the comparison rules are type specific: BLOB The ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-api-definition.html
(NDB 9.7.0) The Id is an integer value used to identify the node in all cluster internal messages. (NDB 9.7.0) The NodeId is an integer value used to identify the node in all cluster internal messages. LocationDomainId Version (or later) NDB 9.7.0 ... 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 ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-config.html
(To obtain configuration data from the management node instead, simply omit this option.) --connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-types.html
The function may consist of any expression valid in MySQL that yields an integer value. These columns can contain other than integer values, since the hashing function supplied by MySQL guarantees an integer result regardless of the column data type. Other partitioning types require a partitioning expression that yields an integer value or ...
https://dev.mysql.com/doc/refman/9.7/en/precision-math-rounding.html
This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and integer). The ROUND() function rounds differently depending on whether its argument is exact or approximate: ...
https://dev.mysql.com/doc/refman/9.7/en/telemetry-trace-configuration.html
Server Configuration Client Configuration Client Configuration Example Server Configuration The following are the server trace telemetry configuration variables: telemetry.trace_enabled System Variable telemetry.trace_enabled Scope Global Dynamic ...
https://dev.mysql.com/doc/refman/9.7/en/cast-functions.html
For numeric operators (such as + or -) where one of the operands is an unsigned integer, the result is unsigned by default (see Section 14.6.1, “Arithmetic Operators”). To override this, use the SIGNED or UNSIGNED cast operator to cast a value ... Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string Yes CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data type to ...
https://dev.mysql.com/doc/refman/9.7/en/clone-plugin-options-variables.html
clone_buffer_size Command-Line Format --clone-buffer-size System Variable clone_buffer_size Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 4194304 Minimum Value 1048576 Maximum Value 268435456 Unit bytes Defines the size ... This section describes the system variables that control operation of the clone ...
https://dev.mysql.com/doc/refman/9.7/en/create-index.html
If there is a PRIMARY KEY but it does not consist of a single integer column, _rowid cannot be used. Otherwise, _rowid refers to the column in the first UNIQUE NOT NULL index if that index consists of a single integer column. If the first UNIQUE NOT ... CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ...
https://dev.mysql.com/doc/refman/9.7/en/keyring-functions-general-purpose.html
Return value: Returns the key length in bytes as an integer for success, NULL if the key does not exist, or NULL and an error for failure. MySQL Server supports a keyring service that enables internal components and plugins to store sensitive ...