mysql数据类型（MySQL data type）.docVIP

mysql数据类型（MySQL data type） MySQL data types (posted) The numeric data types of MySQL can be roughly divided into two categories, one is integer and the other is floating point or decimal. Many different sub types of each one of these categories are available, each sub type supports different size of data, and MySQL allows us to specify the numerical values in the field are divided into positive and negative or zero fill. Tables list various numeric types, their allowable ranges, and the memory space occupied. Type, size, range (signed), range (unsigned) use TINYINT 1 bytes (-128127) (0255) small integer values SMALLINT 2 bytes (-32 768, 32767) (0, 65535) large integer values MEDIUMINT 3 bytes (-8 388608, 8388607) (0, large integer values INT or INTEGER 4 bytes (-2 147483648, 2147483647) (0, 4294967295) large integer values BIGINT 8 bytes (-9, 233372036854775808, 922337203685477580) (0, 18446744073709551, 615) maximum integer value FLOAT 4 bytes (-3.402 823466 E+38, 1.175494351 E-38), 0, (1.175494351 E-38, 3.402823466351 E+38) 0, (1.175494351 E-38, 3.402823466 E+38) single precision Floating-Point Number DOUBLE 8 bytes (1.7976931348623157 E+308, 2.2250738585072014 E-308), 0, (2.2250738585072014 E-308, 1.7976931348623157 E+308) 0, (2.2250738585072014 E-308, 1.7976931348623157 E+308) double precision Floating-Point Number DECIMAL to DECIMAL (M, D), if MD is M+2, otherwise D+2 is dependent on the value of M and D, depending on the small values of the values of M and D INT type The 5 main integer types supported in MySQL are TINYINT, SMALLINT, MEDIUMINT, INT, and BIGINT. These types are largely the same, and only the values they store are not the same. MySQL extends the SQL standard in the form of an optional display width indicator, so that when you retrieve a value from the database, you can extend the value to the specified length. For example, specifying a field type of INT (6) guarantees that the number containing less than 6 values can be automatically fi