MySOL 位运算

位运算符 

&         |         ^         ~         >>         <<

select 12 & 5 ,12 | 5 , 12 ^ 5  from dual;

select 10 & ~1 from dual;

select 4<<1,8>>1 from dual;

#     
#     0 0 0 0 0 1 0 0         4
#   0 0 0 0 0 1 0 0           8
#     
#     0 0 0 0 0 1 0 0         8
#       0 0 0 0 1 0 0 0       4