SQL Operators
Operators manipulate and transform columns within a statement.
Numeric Operators
The portable numeric operators include:
Unary operator |
Meaning |
- |
Negation |
Binary operator |
Meaning |
+ |
Addition |
- |
Subtraction |
* |
Multiplication |
/ |
Division |
% |
Modulo |
& |
Bitwise AND |
| |
Bitwise OR |
^ |
Bitwise XOR |
Certain implementations, such as MariaDB, offer the following:
Binary operator |
Meaning |
<< |
Bit shift left |
>> |
Bit shift right |
String Operators
The only portable string operator is:
Binary operator |
Meaning |
|| |
Concatenation |