group_bit_and

description

Syntax

expr GROUP_BIT_AND(expr)

对expr进行 and 计算, 返回新的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)
  11. mysql> select group_bit_and(value) from group_bit;
  12. +------------------------+
  13. | group_bit_and(`value`) |
  14. +------------------------+
  15. | 0 |
  16. +------------------------+

keywords

  1. GROUP_BIT_AND,BIT