Name
DOUBLE
Syntax
DOUBLE[(display_size, digits)] [ZEROFILL]
Storage
8 bytes
Description
A double-precision floating-point number. This type stores large
floating-point values. DOUBLE
columns can store
negative values between -1.7976931348623157E+308 and
-2.2250738585072014E-308, 0, and positive numbers between
2.2250738585072014E-308 and 1.7976931348623157E+308.
Get Managing & Using MySQL, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.