MySQL Learning notes-types of floating-point numbers and fixed-point numbers for data types

Most of this article is from the simple MySQL primer.

Integer type	Number of bytes	Range of negative values	Range of non-negative values
Float	4	-3.402823466e+38~-1.175494351e-38	0 and 1.175494351e-38~3.402823466e+38
Double	8	-1.7976931348623157e+308~-2.2250738585072014e-308	0 and 2.2250738585072014e-308~1.7976931348623157e+308
Decimal (m,d) or Dec (m,d)	M+2	Same double type	Same double type

This article is from the "Last Night Stars" blog, please make sure to keep this source http://yestreenstars.blog.51cto.com/1836303/1552279

MySQL Learning notes-types of floating-point numbers and fixed-point numbers for data types