sqldatatypes – MySQL ; Best data type for large numbers

sqldatatypes – MySQL ; Best data type for large numbers

MySQL Integer Types (Exact Value):

enter

Fixed-Point Types (Exact Value) – DECIMAL, NUMERIC:

In standard SQL, the syntax DECIMAL(M) is equivalent to DECIMAL(M,0).
Similarly, the syntax DECIMAL is equivalent to DECIMAL(M,0), where the
implementation is permitted to decide the value of M. MySQL supports
both of these variant forms of DECIMAL syntax. The default value of M
is 10.

If the scale is 0, DECIMAL values contain no decimal point or
fractional part.

The maximum number of digits for DECIMAL is 65, but the actual range
for a given DECIMAL column can be constrained by the precision or
scale for a given column. When such a column is assigned a value with
more digits following the decimal point than are permitted by the
specified scale, the value is converted to that scale. (The precise
behavior is operating system-specific, but generally the effect is
truncation to the permissible number of digits.)

Storage Requirements:

enter


enter

sqldatatypes – MySQL ; Best data type for large numbers

Leave a Reply

Your email address will not be published. Required fields are marked *