MySQL BIT_XOR Function

MySQL BIT_XOR is one of the Aggregate Functions which performs Bitwise XOR operation on all bits. First, this BIT_XOR function converts all decimal values into binary values and performs bitwise XOR ( X AND (NOT Y)) operation on those binary values.

MySQL BIT_XOR Syntax

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

SELECT BIT_XOR (Expression)
FROM [Source]

The Truth Table behind this Bitwise XOR function is

xyx BIT_XOR y
000
011
101
110

MySQL BIT_XOR Function Example

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

Source Table 1

The below statement finds the Bitwise XOR values of Sales 1 and Sales 2 columns.

-- Example
USE company;
SELECT BIT_XOR(Sales1),
       BIT_XOR(Sales2)
FROM dupemploy2;
Bitwise XOR Example 2

x = 9 = 1001

y = 12 = 1100

and the MySQL Bitwise XOR for the above bits is 0101 = 0 + 4 + 0 + 1 = 5

BIT_XOR Group By Example

In this example, we are going to use the Bitwise XOR function along with the Group By clause. For this Bit_XOR Aggregate Function demo, We are going to use the below shown data.

Customer Table 1

XOR CODE

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

About Suresh

Suresh is the founder of TutorialGateway and a freelance software developer. He specialized in Designing and Developing Windows and Web applications. The experience he gained in Programming and BI integration, and reporting tools translates into this blog. You can find him on Facebook or Twitter.