MySQL BIT_XOR Function

MySQL BIT_XOR is one of the Aggregate Function, which performs Bit wise XOR operation on all bits. First, this function will convert all decimal values into binary values, and perform bit wise XOR ( X AND (NOT Y)) operation on those binary values. In this article we will show you, How to use this BIT_XOR in MySQL with example.

MySQL BIT_XOR Syntax

The basic syntax of the BIT_XOR Function in MySQL is as shown below:

SELECT BIT_XOR (Expression)
FROM [Source]

Truth Table behind this function is

x	y	x BIT_XOR y
0	0	0
0	1	1
1	0	1
1	1	0

MySQL BIT_XOR Function Example 1

In this example, we will implement the Bitwise XOR function on different columns in a table. To demonstrate the same, we are going to use the dup employee 2 table data that we shown below

Below statement will find the Bit wise XOR values of Sales 1 and Sales 2 columns.

-- MySQL BIT_XOR Function Example
USE company;
SELECT BIT_XOR(Sales1),
       BIT_XOR(Sales2)
FROM dupemploy2;

OUTPUT

x = 9 = 1001

y = 12 = 1100

and the Bit wise XOR for the above bits is 0101 = 0 + 4 + 0 + 1 = 5

MySQL BIT_XOR – Group By Example

In this example, we are going to use the Bit wise XOR function along with the Group By clause. For this, We are going to use the below shown data

CODE

-- MySQL Bitwise XOR Function Example
USE company;
SELECT Education,
       BIT_XOR(Yearly_Income)
FROM dupcustomerdetails
GROUP BY Education;

OUTPUT

Thank You for Visiting Our Blog