VeloDB Cloud
SQL Manual
Functions
bitwise-functions
bitxor

bitxor

Description

Syntax:

BITXOR(Integer-type lhs, Integer-type rhs)

This function returns the result of XOR operation of two integers.

Integer range: TINYINT、SMALLINT、INT、BIGINT、LARGEINT

Example

mysql> select bitxor(3,5) ans;
+------+
| ans  |
+------+
|    7 |
+------+

mysql> select bitxor(1,7) ans;
+------+
| ans  |
+------+
|    6 |
+------+

Keywords

BITXOR