MySQL Data Types

MySQL database offers many data types to serve all kind of data storage and processing.

Numeric Types
MySQL uses all the standard ANSI SQL numeric data types.

INT - Signed from -2147483648 to 2147483647. Unsigned from 0 to 4294967295. Width of up to 11 digits.
TINYINT - Signed from -128 to 127. Unsigned from 0 to 255. Width of up to 4 digits.
SMALLINT - Signed from -32768 to 32767. Unsigned from 0 to 65535. Width of up to 5 digits.
MEDIUMINT - Signed from -8388608 to 8388607. Unsigned from 0 to 16777215. Width of up to 9 digits.
BIGINT - Signed from -9223372036854775808 to 9223372036854775807. Unsigned from 0 to 18446744073709551615. Width of up to 20 digits.
FLOAT(M,D) - Floating-point, unsigned, M -> total display length, D -> number of decimals, If (M,D) not given, defaults to (10,2), Decimal precision up to 24 places for a FLOAT.
DOUBLE(M,D) - Double Precision Floating-point, unsigned, M -> total display length, D -> number of decimals, If (M,D) not given, defaults to (16,4), Decimal precision up to 53 places for a FLOAT. Also called REAL.
DECIMAL(M,D) - Unpacked Floating-point, unsigned, M -> total display length, D -> number of decimals, If (M,D) not given, defaults to (16,4), Decimal precision up to 53 places for a FLOAT. Also called NUMERIC. In the unpacked decimals, each decimal corresponds to one byte.

Loading comments...