PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/number-literals.html
Number literals include exact-value (integer and DECIMAL) literals and approximate-value (floating-point) literals. The DECIMAL data type is a fixed-point type and calculations are exact. In MySQL, the DECIMAL type has several synonyms: NUMERIC, ...
https://dev.mysql.com/doc/refman/5.7/en/problems-with-float.html
For DECIMAL columns, MySQL performs operations with a precision of 65 decimal digits, which should solve most common inaccuracy problems. If columns d1 and d2 had been defined as DECIMAL rather than DOUBLE, the result of the SELECT query would have ... Floating-point numbers sometimes cause confusion because they are approximate and not stored as exact ...
https://dev.mysql.com/doc/refman/5.7/en/cast-functions.html
For example, the following pairs of definitions are equivalent: CHAR(10) CHARACTER SET binary BINARY(10) VARCHAR(10) CHARACTER SET binary VARBINARY(10) TEXT CHARACTER SET binary BLOB If BINARY is invoked from within the mysql client, binary strings ... Table 12.15 Cast Functions and Operators Name Description BINARY Cast a string to a binary string CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data type to ...
https://dev.mysql.com/doc/refman/5.7/en/can-not-connect-to-server.html
The valid range is between 30 and 300 decimal, although you may wish to check with Microsoft for the latest permitted values. A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect ...
https://dev.mysql.com/doc/refman/5.7/en/create-function-loadable.html
CREATE [AGGREGATE] FUNCTION 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 functions ...
https://dev.mysql.com/doc/refman/5.7/en/storage-requirements.html
InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/date-and-time-literals.html
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 seconds delimiter is ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/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: ...