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/choosing-types.html
All basic calculations (+, -, *, and /) with DECIMAL columns are done with precision of 65 decimal (base 10) digits. For optimum storage, you should try to use the most precise type in all cases. For example, if an integer column is used for values ...
https://dev.mysql.com/doc/refman/9.7/en/set.html
For a column specified as SET('a','b','c','d'), the members have the following decimal and binary values. A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the ...
https://dev.mysql.com/doc/refman/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/en/data-types.html
D applies to floating-point and fixed-point types and indicates the number of digits following the decimal point (the scale). fsp applies to the TIME, DATETIME, and TIMESTAMP types and represents fractional seconds precision; that is, the number of ... MySQL supports SQL data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, and the JSON data ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-floatvalues.html
With statement-based replication, values are converted from decimal to binary. Because conversions between decimal and binary representations of them may be approximate, comparisons involving floating-point values are inexact. This is true for ...
https://dev.mysql.com/doc/refman/9.7/en/numeric-types.html
These types include the exact numeric data types (INTEGER, SMALLINT, DECIMAL, and NUMERIC), as well as the approximate numeric data types (FLOAT, REAL, and DOUBLE PRECISION). The keyword INT is a synonym for INTEGER, and the keywords DEC and FIXED ...MySQL treats DOUBLE as a synonym for DOUBLE PRECISION (a nonstandard ...
https://dev.mysql.com/doc/refman/9.7/en/comparison-operators.html
Otherwise, if at least one argument is a DECIMAL value, they are compared as DECIMAL values. Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator ...
https://dev.mysql.com/doc/refman/9.7/en/datetime.html
The fractional part should always be separated from the rest of the time by a decimal point; no other fractional seconds delimiter is recognized. The only delimiter recognized between a date and time part and a fractional seconds part is the decimal ...This section describes their characteristics, how they are similar, and how they ...
https://dev.mysql.com/doc/refman/9.7/en/prepare.html
The parameter's derived type is DECIMAL and its actual type is either DECIMAL or INTEGER. PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to refer to the statement ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-foreign-keys.html
The size and sign of fixed precision types such as INTEGER and DECIMAL must be the same. MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...