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