PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/arithmetic-functions.html
Table 14.9 Arithmetic Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument / Division operator DIV Integer division The usual arithmetic operators are ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-reference.html
audit_log_filter_id System Variable audit_log_filter_id Scope Global, Session Dynamic No SET_VAR Hint Applies No Type Integer Default Value 1 Minimum Value 0 Maximum Value 4294967295 The session value of this variable indicates the internally ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html
mysql> SELECT DATE_ADD('2008-01-02', INTERVAL 31 DAY); -> '2008-02-02' mysql> SELECT ADDDATE('2008-01-02', INTERVAL 31 DAY); -> '2008-02-02' When invoked with the days form of the second argument, MySQL treats it as an integer number of days to be ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html
Otherwise, the result is an integer type (with one exception): If all integer types are all signed or all unsigned, the result is the same sign and the precision is the highest of all specified integer types (that is, TINYINT, SMALLINT, MEDIUMINT, ...The second syntax returns the result for the first condition that is ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/mysql-cluster-api-definition.html
(NDB 8.0.13) The Id is an integer value used to identify the node in all cluster internal messages. (NDB 8.0.13) The NodeId is an integer value used to identify the node in all cluster internal messages. LocationDomainId Version (or later) NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-config.html
--nodeid=node_id Command-Line Format --ndb-nodeid=# Removed 8.0.31 Type Integer Default Value [none] Specify the node ID of the node for which configuration information is to be obtained. --ndb-nodeid Command-Line Format --ndb-nodeid=# Removed ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/pluggable-authentication-system-variables.html
authentication_ldap_sasl_init_pool_size Command-Line Format --authentication-ldap-sasl-init-pool-size=# System Variable authentication_ldap_sasl_init_pool_size Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 10 Minimum ...
https://dev.mysql.com/doc/refman/8.0/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: ...