Subtraction: - : Arithmetic Operators « Math Numeric Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. Math Numeric Functions
  3. Arithmetic Operators
mysql>
mysql> SELECT 3-5;
+-----+
| 3-5 |
+-----+
|  -2 |
+-----+
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: /