MySQL data type

1. Integral type (distinguishing signed or unsigned) Yinyint: one byte; SMALLINT: two bytes; Mediunint: three bytes; INT: four bytes; BIGINT: eight bytes

2. Floating-point and fixed-point floating point type float[(M,d)] (4 bytes) and double[(M,D)] (8 bytes) fixed-point type decimal[(m,d)], high precision, can be used for currency calculation and other requirements of high precision M is precision = integer digit + decimal place D is the scale = decimal place floating point type in the database is the approximate value, fixed-point type is stored in the exact value. 3. Time and date type 4. character type character type in addition to the ability to store string data, you can also store other data, compared to slices and sound binary data.

MySQL data type