Bit Functions and Operators
Operators for comparison and setting of values, and related functions. They all return a result of the BIGINT UNSIGNED type
-
Operator Precedence
Precedence of SQL operators -
&
Bitwise AND -
<<
Left shift -
>>
Shift right -
BIT_COUNT
Returns the number of set bits -
^
Bitwise XOR -
|
Bitwise OR -
~
Bitwise NOT -
Parentheses
Parentheses modify the precedence of other operators in an expression -
TRUE FALSE
TRUE and FALSE evaluate to 1 and 0
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
