Skip to content

Mathematical Operators

M-SQL Operator Description
+ Addition operator adds 2 numbers or dates. Does not work on strings

select `Replacement Cost` + id + Length as exprVal from `films`
- Subtraction operator subtracts 2 numbers or dates. Does not work on strings

select `Replacement Cost` - id - Length as exprVal from `films`
/ Division operator divides 2 numbers or dates. Does not work on strings

select `Replacement Cost` / id as exprVal from `films`
* Multiplication operator multiplies 2 numbers or dates. Does not work on strings

select `Replacement Cost` *id* Length as exprVal from `films`
% Modulus operator

select `id` % Length as exprVal from `films`