Data Types MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Data Types
  4. 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>