PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/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 8.0.27 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/8.0/en/clone-plugin-options-variables.html
clone_buffer_size Command-Line Format --clone-buffer-size Introduced 8.0.17 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 ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
Another effect of this change is that evaluation of a JSON value in an SQL boolean context performs an implicit comparison against JSON integer 0. Such implicit casts are now performed between temporal types (DATE, DATETIME, TIMESTAMP, TIME) and ...
https://dev.mysql.com/doc/refman/8.0/en/server-options.html
--debug-sync-timeout[=N] Command-Line Format --debug-sync-timeout[=#] Type Integer Controls whether the Debug Sync facility for testing and debugging is enabled. --exit-info[=flags], -T [flags] Command-Line Format --exit-info[=flags] Type Integer ...
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html
In MySQL 8.0.3 and earlier, when evaluating the expression LEAST("11", "45", "2") + 0, the server converted the arguments to integers (anticipating the addition of integer 0 to the result) before sorting them, thus returning 2. This means that, in ... Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...
https://dev.mysql.com/doc/refman/8.0/en/explain.html
{EXPLAIN | DESCRIBE | DESC} tbl_name [col_name | wild] {EXPLAIN | DESCRIBE | DESC} [explain_type] {explainable_stmt | FOR CONNECTION connection_id} {EXPLAIN | DESCRIBE | DESC} ANALYZE [explain_type] select_stmt explain_type: { FORMAT = format_name ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-mgm-definition.html
For a management node, this is represented by an integer value in the range 1 to 255, inclusive. For a management node, this is represented by an integer value in the range 1 to 255 inclusive. LocationDomainId Version (or later) NDB 8.0.13 Type or ... The [ndb_mgmd] section is used to configure the behavior of the management ...