https://dev.mysql.com/arithmetic-functions.html
For information about handling of overflow in numeric expression evaluation, see Section 11.2.6, “Out-of-Range and Overflow Handling”. (See Section 11.2, “Numeric Types”.) / Division: mysql> SELECT 3/5; -> 0.60 Division by zero produces a ...
https://dev.mysql.com/audit-log-file-formats.html
Characters not valid as XML characters are encoded using numeric character references. Characters not valid as XML characters are encoded using numeric character references. The MySQL server calls the audit log plugin to write an audit record to ...
https://dev.mysql.com/charset-collation-coercibility.html
The collation of a numeric or temporal value has a coercibility of 5. In the great majority of statements, it is obvious what collation MySQL uses to resolve a comparison operation. For example, in the following cases, it should be clear that the ...
https://dev.mysql.com/charset-collation-names.html
For the binary collation of the binary character set, comparisons are based on numeric byte values. For the _bin collation of a nonbinary character set, comparisons are based on numeric character code values, which differ from byte values for ...
https://dev.mysql.com/charset-introducer.html
For example, bit operations permit numeric or binary string arguments in MySQL 8.0 and higher, but treat hexadecimal and bit literals as numbers by default. Due to the difference in result types, the displayed values differ: High-order 0 digits are ... A character string literal, hexadecimal literal, or bit-value literal may have an optional character set introducer and COLLATE clause, to designate it as a string that uses a particular character set and collation: [_charset_name] literal [COLLATE collation_name] The _charset_name expression is formally called an ...
https://dev.mysql.com/control-flow-functions.html
The return type of a CASE expression result is the aggregated type of all result values: If all types are numeric, the aggregated type is also numeric: If at least one argument is double precision, the result is double precision. The second syntax ...
https://dev.mysql.com/create-table.html
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name (create_definition,...) [table_options] [partition_options] CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)] [table_options] [partition_options] [IGNORE | REPLACE] [AS] ...
https://dev.mysql.com/error-message-components.html
These components have the following characteristics: Error code: This value is numeric. SQLSTATE values are taken from ANSI SQL and ODBC and are more standardized than the numeric error codes. This section discusses how error messages originate ...
https://dev.mysql.com/events-configuration.html
Events are executed by a special event scheduler thread; when we refer to the Event Scheduler, we actually refer to this thread. When running, the event scheduler thread and its current state can be seen by users having the PROCESS privilege in the ...
https://dev.mysql.com/floating-point-types.html
The FLOAT and DOUBLE types represent approximate numeric data values. For more information, see Section B.4.4.8, “Problems with Floating-Point Values” For maximum portability, code requiring storage of approximate numeric data values should use ...MySQL uses four bytes for single-precision values and eight bytes for double-precision ...
