Table 4. Operators and precedence order
Operator | Name | Order of Precedence |
---|---|---|
* |
Multiplication |
1 |
/ |
Division |
1 |
DIV |
Integer Division |
1 |
% (MOD) |
Modulo (remainder) |
1 |
+ |
Addition |
2 |
- |
Subtraction |
2 |
Code Example:
USE world;
SELECT name, population / SurfaceArea
AS "People per square mile"
FROM country;
Results:
This content is provided to you freely by BYU-I Books.
Access it online or download it at https://books.byui.edu/learning_mysql/14_arithmetic_operat.