PDF (US Ltr)
- 43.1Mb
PDF (A4)
- 43.2Mb
Man Pages (TGZ)
- 295.4Kb
Man Pages (Zip)
- 400.6Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/arithmetic-functions.html
For example, the result of the expression 5.05 / 0.014 has a scale of six decimal places (360.714286). Hence, (14620 / 9432456) / (24250 / 9432456), resolves first to (0.0014) / (0.0026), with the final result having 8 decimal places (0.60288653).
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html
If CHAR() is invoked from within the mysql client, binary strings display using hexadecimal notation, depending on the value of the --binary-as-hex. mysql> SELECT FIND_IN_SET('b','a,b,c,d'); -> 2 FORMAT(X,D[,locale]) Formats the number X to a format ...For functions that operate on string positions, the first position is ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
Such implicit casts are now performed between temporal types (DATE, DATETIME, TIMESTAMP, TIME) and numeric types (SMALLINT, TINYINT, MEDIUMINT, INT/INTEGER, BIGINT; DECIMAL/NUMERIC; FLOAT, DOUBLE, REAL; BIT) whenever they are compared using any of ... This section summarizes what has been added to, deprecated in, and removed from MySQL ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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/8.0/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: ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-numbers.html
The scope of precision math for exact-value operations includes the exact-value data types (integer and DECIMAL types) and exact-value numeric literals. The DECIMAL data type is a fixed-point type and calculations are exact. In MySQL, the DECIMAL ...Approximate-value data types and numeric literals are handled as floating-point ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/en/other-vendor-data-types.html
To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...