https://dev.mysql.com/numeric-functions.html
Table 12.10 Numeric Functions and Operators Name Description ABS() Return the absolute value ACOS() Return the arc cosine ASIN() Return the arc sine ATAN() Return the arc tangent ATAN2(), ATAN() Return the arc tangent of the two arguments CEIL() ...
https://dev.mysql.com/osx-installation-launchd.html
macOS uses launch daemons to automatically start, stop, and manage processes and applications such as MySQL. The md5 checksum of a file containing the above snippet is d925f05f6d1b6ee5ce5451b596d6baed. To enable the launchd service, you can either: ...
https://dev.mysql.com/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/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 23.2, “Partitioning Types”, for more information). A partitioning key must be either an ...
https://dev.mysql.com/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/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/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/window-function-descriptions.html
This section describes nonaggregate window functions that, for each row from a query, perform a calculation using rows related to that row. Most aggregate functions also can be used as window functions; see Section 12.20.1, “Aggregate (GROUP BY) ...
https://dev.mysql.com/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/connection-control-variables.html
connection_control_max_connection_delay Property Value Command-Line Format --connection-control-max-connection-delay=# Introduced 8.0.1 System Variable connection_control_max_connection_delay Scope Global Dynamic Yes SET_VAR Hint Applies No Type ...
