Mega Code Archive

 

Categories / MySQL Tutorial / Data Types

 

For floating-point values, results are inexact

mysql> mysql> SELECT .1E0 + .2E0 = .3E0; +--------------------+ | .1E0 + .2E0 = .3E0 | +--------------------+ |                  0 | +--------------------+ 1 row in set (0.00 sec) mysql> SELECT .1 + .2 = .3; +--------------+ | .1 + .2 = .3 | +--------------+ |            1 | +--------------+ 1 row in set (0.00 sec) mysql>