Division by zero produces a NULL result : Arithmetic Operators « Math Numeric Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Math Numeric Functions
  3. Arithmetic Operators
mysql>
mysql> SELECT 102/(1-1);
+-----------+
| 102/(1-1) |
+-----------+
|      NULL |
+-----------+
1 row in set (0.00 sec)

mysql>
mysql>
mysql>








21.2.Arithmetic Operators
21.2.1.Addition: +
21.2.2.Subtraction: -
21.2.3.Using Arithmetic Operators in select statement
21.2.4.Unary minus: -
21.2.5.Multiplication: *
21.2.6.Division by zero produces a NULL result
21.2.7.Division: /