Division: / : Arithmetic Operators « Math Numeric Functions « MySQL Tutorial






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

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: /