Mega Code Archive

 
Categories / MySQL Tutorial / Introduction
 

To override this order and group terms explicitly, use parentheses

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>