= SQL Operators =

'''Operators''' manipulate and transform columns within a statement.

<<TableOfContents>>

----



== 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||



----
CategoryRicottone