SQLite Bitwise Operators
SQLite Bitwise Operators
SQLite Bitwise operators, also called binary Operators, are used to perform bitwise operations. SQLite uses two’s complement representation for signed integers. It is important to consider the representation of signed integers when working with bitwise operators in SQLite.
Bitwise operators work on bits and perform bit-by-bit operations. SQLite Bitwise operators are as follows in a table format:
SQLite Bitwise
Operator |
Name | Description |
& | Binary AND Operator | The bitwise AND operator is a binary operator. The result of the binary AND operation is 1 only if both the bits in the corresponding positions are 1; otherwise, the result is 0. |
| | Binary OR Operator | The bitwise OR operator is a binary operator. The result of the OR operation is 1 if at least one of the bits in the corresponding positions is 1; otherwise, the result is 0. |
~ | Binary NOT Operator
|
The bitwise NOT operator is a unary operator that performs a bitwise NOT operation on each bit of an integer. The bitwise NOT operation flips each bit, changing 0s to 1s and 1s to 0s. |
^ | Binary XOR Operator | The bitwise XOR operator is a binary operator that performs a bitwise exclusive OR (XOR) operation on each pair of corresponding bits. The result of the XOR operation is 1 if the bits in the corresponding positions are different; otherwise, the result is 0. |
<< | Left-Shift Operator | The left operand’s value is moved left by the number of bits specified by the right operand. The right places are padded with 0s. |
>> | Right-Shift Operator | The left operand’s value is moved right by the number of bits specified by the right operand. The left places are padded with 0s. |
SQLite Tutorials
SQLite tutorials on this website:
https://www.testingdocs.com/sqlite-database-tutorials/