HIOX FREE MySQL Tutorial - MySql Numeric Data types

Topic

What are the Numeric data types in Mysql?

Explanation

Numeric Datatypes :

The numeric data types are as follows:

BIT	TINYINT	BOOLEAN
SMALLINT	MEDIUMINT	INT
INTEGER	BIGINT	FLOAT
DOUBLE	DECIMAL

    Lets see the numeric datatypes briefly.

BIT :

    BIT is a synonym for TINYINT(1).

TINYINT[(M)] :

    A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255.

BOOL, BOOLEAN :

    These types are synonyms for TINYINT(1). A value of zero is considered false. Non-zero values are considered true.

SMALLINT :

    A small integer. The signed range is -32768 to 32767. The unsigned range is 0 to 65535.

MEDIUMINT :

    A medium-sized integer. The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215.

INT :

    A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295.

INTEGER :

    This type is a synonym for INT.

BIGINT :

    A large integer. The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615.

FLOAT :

    A small(single-precision) floating-point number. The values are from 3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38.

DOUBLE :

    A normal-size(double-precision) floating-point number. The values are from 1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308.

DECIMAL :

    The maximum number of digits(M) for DECIMAL is 64.