Skip to main content
Version: Latest-3.2

bitxor

Description​

Returns the bitwise XOR of two numeric expressions.

Syntax​

BITXOR(x,y);

Parameters​

  • x: This expression must evaluate to any of the following data types: TINYINT, SMALLINT, INT, BIGINT, LARGEINT.

  • y: This expression must evaluate to any of the following data types: TINYINT, SMALLINT, INT, BIGINT, LARGEINT.

x and y must agree in data type.

Return value​

The return value has the same type as x. If any value is NULL, the result is NULL.

Examples​

mysql> select bitxor(3,0);
+--------------+
| bitxor(3, 0) |
+--------------+
|            3 |
+--------------+
1 row in set (0.00 sec)