mysql学习笔记之bit_and和bit_or（2）

来源：互联网发布：网络教学平台系统编辑：程序博客网时间：2024/06/08 17:48

刚刚看了bit_or和bit_and的函数，这两个函数我觉得挺有用的。

mysql> use csong;Database changedmysql> create table csong_tab_1230(id int,customer_id int,kind int);Query OK, 0 rows affected (0.16 sec)mysql> insert into csong_tab_1230 values(1,1,5),(2,1,4),(3,2,3),(4,2,4);Query OK, 4 rows affected (0.14 sec)Records: 4  Duplicates: 0  Warnings: 0mysql> commit;Query OK, 0 rows affected (0.00 sec)mysql> select * from csong_tab_1230;+------+-------------+------+| id   | customer_id | kind |+------+-------------+------+|    1 |           1 |    5 ||    2 |           1 |    4 ||    3 |           2 |    3 ||    4 |           2 |    4 |+------+-------------+------+4 rows in set (0.00 sec)

mysql> select customer_id,bit_or(kind) from csong_tab_1230 group by customer_id;+-------------+--------------+| customer_id | bit_or(kind) |+-------------+--------------+|        1 |        5 ||        2 |        7 |+-------------+--------------+2 rows in set (0.00 sec)mysql> select customer_id,bit_and(kind) from csong_tab_1230 group by customer_id;+-------------+---------------+| customer_id | bit_and(kind) |+-------------+---------------+|        1 |         4 ||        2 |           0 |+-------------+---------------+2 rows in set (0.00 sec)

1 0