mysql date 类型（类型MySQL日期）.docVIP

mysql date 类型（类型MySQL日期） Blog news new essays on the contact management subscription - 79 - 0 the essay reviews numerical data - 10 MySQL data type MySQL type can be divided into two categories, one is an integer, the other is a float 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 n