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/numeric-functions.html
Table 14.8 Numeric Functions and Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument / Division operator ABS() Return the absolute value ACOS() Return ...
https://dev.mysql.com/doc/refman/8.0/en/out-of-range-and-overflow.html
When an out-of-range value is assigned to an integer column, MySQL stores the value representing the corresponding endpoint of the column data type range. If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
However, the result must be an integer value or NULL (except in the case of [LINEAR] KEY partitioning, as discussed elsewhere in this chapter; see Section 26.2, “Partitioning Types”, for more information). A partitioning key must be either an ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-list.html
This is done by using PARTITION BY LIST(expr) where expr is a column value or an expression based on a column value and returning an integer value, and then defining each partition by means of a VALUES IN (value_list), where value_list is a ... List ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-decimal-characteristics.html
The storage requirements for the integer and fractional parts of each value are determined separately. Leftover Digits Number of Bytes 0 0 1–2 1 3–4 2 5–6 3 7–9 4 For example, a DECIMAL(18,9) column has nine digits on either side of the ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-examples.html
Rounding for exact-value columns (DECIMAL and integer) and exact-valued numbers uses the “round half away from zero” rule. A value with a fractional part exactly half way between two integers is rounded to the nearest even integer: mysql> SELECT ... This section provides some examples that show precision math query results in ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table-examples.html
For NDB tables, it is also possible to change the storage type used for a table or column. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ...
https://dev.mysql.com/doc/refman/8.0/en/connection-control-plugin-variables.html
connection_control_max_connection_delay Command-Line Format --connection-control-max-connection-delay=# System Variable connection_control_max_connection_delay Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 2147483647 ...
https://dev.mysql.com/doc/refman/8.0/en/converting-tables-to-innodb.html
For the ranges of the different integer types, see Section 13.1.2, “Integer Types (Exact Value) - INTEGER, INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT”. If you have MyISAM tables that you want to convert to InnoDB for better reliability and ...
https://dev.mysql.com/doc/refman/8.0/en/create-resource-group.html
If VCPU is given, the attribute value is a list of comma-separated CPU numbers or ranges: Each number must be an integer in the range from 0 to the number of CPUs − 1. If a CPU number is an integer outside the permitted range or is not an integer, ... CREATE RESOURCE GROUP group_name TYPE = {SYSTEM|USER} [VCPU [=] vcpu_spec [, vcpu_spec] ...] [THREAD_PRIORITY [=] N] [ENABLE|DISABLE] vcpu_spec: {N | M - N} CREATE RESOURCE GROUP is used for resource group management (see Section 7.1.16, “Resource ...