PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/type-conversion.html
Hexadecimal values are treated as binary strings if not compared to a number. If one of the arguments is a decimal value, comparison depends on the other argument. The arguments are compared as decimal values if the other argument is a decimal or ...
https://dev.mysql.com/doc/refman/9.7/en/precision-math-expressions.html
In strict SQL mode, for INSERT into a column with an exact data type (DECIMAL or integer), a number is inserted with its exact value if it is within the column range. If any exact value contains a fractional part (a value following the decimal ...
https://dev.mysql.com/doc/refman/9.7/en/srjsapi-session.html
sql(String sql, {passResultToClient: Bool, charsetName: String, integerType: IntegerType, decimalType: DecimalType}): Executes a simple SQL statement. DecimalType consists of a JSON key-value pair whose key is DecimalType, and whose possible values ... The Session object is always available as the session property of the global ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.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/9.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/9.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/9.7/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/9.7/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 ...