SmallSQL Database SQL Operators


A operator is a action with one or multiple expressions. There are the follow types of operators:

Arithmetic Operations

operators description
+ addition
- subtraction
* multiplication
/ division
% modulo division


Logical Operators

operators description
AND true if both expressions are true
OR true if one of the expressions true
LIKE true if the expression like a pattern
BETWEEN true if the expression is incite a range
NOT invert the expression
IS [NOT] NULL Determines whether or not a given expression is NULL


Bit Operators

operators description
& bit AND
| bit OR
^ exclusive OR



Comparable Operators

operators description
= equals
> greater than
>= greater than or equals
< lesser than
<= lesser than  or equals
<> unequals


Conversion Operators

operators description
cast convert a data type explicit to another data type.