MySQL Numeric type

Introduction of numerical types

(1) Numeric types are mainly used to store numbers, different value types provide different ranges of values, the larger the range of value can be stored, the greater the storage space required
(2) numeric types are divided into: ① integer type ② floating-point type ③ fixed-point number type

1, Integer type

Integer type	Description	Storage requirements	Signed range of values	Unsigned range of values
TINYINT	A very small integer.	1 bytes	-128 ~ 127	0 ~255
SMALLINT	A small integer	2 bytes	-32768 ~ 32767	0 ~ 65535
Mediumint	A medium-sized integer	3 bytes	-8388608 ~ 8388607	0 ~ 16777215
Int	An integer of normal size	4 bytes	-2147483648 ~ 2147483647	0 ~ 4294967295
BIGINT	Large integer	8 bytes	-9223372036854775808 ~ 9223372036854775807	0 ~ 18446744073709551615

MySQL Numeric type