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/json-search-functions.html
Two scalar values are comparable if they have the same JSON_TYPE() types, with the exception that values of types INTEGER and DECIMAL are also comparable to each other. type is one of the following data types: FLOAT DOUBLE DECIMAL SIGNED UNSIGNED ...
https://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html
Otherwise, if at least one argument is DECIMAL, the result is DECIMAL. The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ELSE is returned, or NULL if there is no ELSE ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-functions.html
The string contains the number of bytes rounded to 2 decimal places and a minimum of 3 significant digits. The string contains the decimal time rounded to 2 decimal places and a minimum of 3 significant digits. As of MySQL 8.0.16, MySQL includes ...
https://dev.mysql.com/doc/refman/8.0/en/expressions.html
This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in expressions. Expression Syntax Expression Term Notes Temporal Intervals Expression Syntax The ...
https://dev.mysql.com/doc/refman/8.0/en/create-function-loadable.html
CREATE [AGGREGATE] FUNCTION [IF NOT EXISTS] function_name RETURNS {STRING|INTEGER|REAL|DECIMAL} SONAME shared_library_name This statement loads the loadable function named function_name. DECIMAL is a legal value after RETURNS, but currently DECIMAL ...(CREATE FUNCTION is also used to created stored functions; see Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) A loadable function is a way to extend MySQL with a new function that works like a native (built-in) MySQL function such as ABS() or ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html
When unix_timestamp is a decimal value, the fractional seconds precision of the DATETIME is the same as the precision of the decimal value, up to a maximum of 6. The return value is an integer if no argument is given or the argument does not include ... This section describes the functions that can be used to manipulate temporal ...
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/date-and-time-literals.html
1 row in set (0.00 sec) The only delimiter recognized between a date and time part and a fractional seconds part is the decimal point. The fractional part should always be separated from the rest of the time by a decimal point; no other fractional ... Standard SQL and ODBC Date and Time Literals String and Numeric Literals in Date and Time Context Date and time values can be represented in several formats, such as quoted strings or as numbers, depending on the exact type of the value and other ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-conversion.html
To some extent, you can convert a value from one temporal type to another. However, there may be some alteration of the value or loss of information. In all cases, conversion between temporal types is subject to the range of valid values for the ...
https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html
The SUM() and AVG() functions return a DECIMAL value for exact-value arguments (integer or DECIMAL), and a DOUBLE value for approximate-value arguments (FLOAT or DOUBLE). The result type depends on whether the function argument values are evaluated ... This section describes aggregate functions that operate on sets of ...