GROUP_BIT_XOR

description

Syntax

expr GROUP_BIT_XOR(expr)

对expr进行 xor 计算, 返回新的expr 支持所有INT类型

example

1. mysql> select * from group_bit;
2. +-------+
3. | value |
4. +-------+
5. |     3 |
6. |     1 |
7. |     2 |
8. |     4 |
9. +-------+
10. 4 rows in set (0.02 sec)

12. mysql> select group_bit_xor(value) from group_bit;
13. +------------------------+
14. | group_bit_xor(`value`) |
15. +------------------------+
16. |                      4 |
17. +------------------------+

keywords

1. GROUP_BIT_XOR,BIT