To override this order and group terms explicitly, use parentheses. : Operator « Introduction « MySQL Tutorial






  1. MySQL Tutorial
  2. Introduction
  3. Operator
mysql>
mysql> SELECT 1+2*3;
+-------+
| 1+2*3 |
+-------+
|     7 |
+-------+
1 row in set (0.00 sec)

mysql>
mysql> SELECT (1+2)*3;
+---------+
| (1+2)*3 |
+---------+
|       9 |
+---------+
1 row in set (0.00 sec)

mysql>
mysql>








1.4.Operator
1.4.1.Operator
1.4.2.Operator precedences
1.4.3.To override this order and group terms explicitly, use parentheses.