double and decimal in MySQL

Mysql Video TutorialThe column summarizes the difference between the three floating point types in MySQL The storage size and range of each floating point type are planned in the following table: type size range (signed) range (unsigned) use ==float== 4 bytes (-3.402 823 466 E+38, -1.175 494 351 E-38), 0, (1.175 494 351 E -38, 3.402 823 466 351 E+38) 0, (1.175 494 351 E-38, 3.402 823 466 E+38) Single-precision floating-point value ==double== 8 bytes (-1.797 693 134 862 315 7 E+308, -2.225073858507 2014E-308), 0, (2.225 073 858 507 201 4 E-308, 1.797 693 134 862 315 7 E+308) 0, (2.225 073 858 507 201 4 E-308, 1.797 693 134 862 315 7 E+308) Double precision floating point Value decimal is for decimal(M,D), if M>D, it is M+2 Otherwise D+2 Depends on the value of M and D Depends on the value of M and D Decimal value Then these three types in MySQL are floating point types and what is the difference between them? ? float floating point type is used to represent==single precision floating point==value, double floating point type is used to represent==double precision floating point Point == value Some friends here must ask what is single precision…