DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info.gz) Bit functions

Info Catalog (mysql.info.gz) Other Functions (mysql.info.gz) Other Functions (mysql.info.gz) Encryption functions
 
 12.8.1 Bit Functions
 --------------------
 
 MySQL uses `BIGINT' (64-bit) arithmetic for bit operations, so these
 operators have a maximum range of 64 bits.
 
 `|'
      Bitwise OR:
 
           mysql> SELECT 29 | 15;
                   -> 31
 
      The result is an unsigned 64-bit integer.
 
 `&'
      Bitwise AND:
 
           mysql> SELECT 29 & 15;
                   -> 13
 
      The result is an unsigned 64-bit integer.
 
 `^'
      Bitwise XOR:
 
           mysql> SELECT 1 ^ 1;
                   -> 0
           mysql> SELECT 1 ^ 0;
                   -> 1
           mysql> SELECT 11 ^ 3;
                   -> 8
 
      The result is an unsigned 64-bit integer.
 
      Bitwise XOR was added in MySQL 4.0.2.
 
      Shifts a longlong (`BIGINT') number to the left.
 
 `<<'
           mysql> SELECT 1 << 2;
                   -> 4
 
      The result is an unsigned 64-bit integer.
 
 `>>'
      Shifts a longlong (`BIGINT') number to the right.
 
           mysql> SELECT 4 >> 2;
                   -> 1
 
      The result is an unsigned 64-bit integer.
 
 `~'
      Invert all bits.
 
           mysql> SELECT 5 & ~1;
                   -> 4
 
      The result is an unsigned 64-bit integer.
 
 `BIT_COUNT(N)'
      Returns the number of bits that are set in the argument N.
 
           mysql> SELECT BIT_COUNT(29);
                   -> 4
 
 
Info Catalog (mysql.info.gz) Other Functions (mysql.info.gz) Other Functions (mysql.info.gz) Encryption functions
automatically generated byinfo2html