Data types supported by MySQL (1)

1. Numeric type

Integer type	Bytes	Minimum value	Maximum Value
tinyint	1	Signed-128 Unsigned 0	Signed 127 Unsigned 255
smallint	2	Signed-32768 Unsigned 0	Signed 32767 unsigned 65535
Mediumint	3	Signed-8388608 Unsigned 0	Signed 8388607 unsigned 1677215
int, integer	4	Signed-2147483648 Unsigned 0	Signed 2147483647 unsigned 4294967295
bigint	8	Signed-9223372036854775808 Unsigned 0	Signed 9223372036854775807 unsigned 18446744073709551615

Floating-point type	Bytes	Minimum value	Maximum Value
Float	4	±1.175494351e-38	±3.402823466e+38
Double	8	±2.2250738585072014e-308	±1.7976931348623157e+308

Fixed-point number types	Bytes	Describe
Dec (m,d)/decimal (M,D)	M+2	The maximum value range is the same as double, and the valid range of values for a given decimal is determined by M and D

Bit type	Bytes	Minimum value	Maximum Value
Bit (m)	1-8	Bit (1)	Bit (64)

Data types supported by MySQL (1)