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/user-variables.html
User variables can be assigned a value from a limited set of data types: integer, decimal, floating-point, binary or nonbinary string, or NULL value. Assignment of decimal and real values does not preserve the precision or scale of the value. (This ... You can store a value in a user-defined variable in one statement and refer to it later in another ...
https://dev.mysql.com/doc/refman/8.0/en/update.html
UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause to define common table expressions accessible within the UPDATE. Single-table syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference SET ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/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/8.0/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/8.0/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/8.0/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 ...