What is the range of values for double in mysql?

When using the double data type in MySQL, it represents double precision floating point numbers using the IEEE 754 standard. This data type occupies 8 bytes (64 bits), with 1 bit for the sign (positive or negative), 11 bits for the exponent, and the remaining 52 bits for the mantissa.

The approximate range of values for the double data type is as follows:

最小正非零值：2.2250738585072014 x 10^-308
最大正值：1.7976931348623157 x 10^308
最小负值：-1.7976931348623157 x 10^308
最大负非零值：-2.2250738585072014 x 10^-308

It is important to note that these values are determined according to the IEEE 754 standard and may vary between different hardware and operating systems. Additionally, due to rounding errors when representing decimals with floating point numbers, it is recommended to use the decimal data type for accurate calculations.

Here is an example showcasing the range of values for the double data type in MySQL.

CREATE TABLE my_table (
  my_double DOUBLE
);
INSERT INTO my_table (my_double) VALUES 
(1.7976931348623157e+308),    -- 最大正值
(-1.7976931348623157e+308),   -- 最小负值
(2.2250738585072014e-308),    -- 最小正非零值
(-2.2250738585072014e-308);   -- 最大负非零值
SELECT * FROM my_table;

After executing the above example, you will see that the double values stored in the database table fall within the specified range.