Apply several binary operators to the columns of the MATCHES table. : Bit « Function « SQL / MySQL






  1. SQL / MySQL
  2. Function
  3. Bit

Apply several binary operators to the columns of the MATCHES table.

        
mysql>
mysql>
mysql> CREATE TABLE MATCHES(
    ->     MATCHNO INTEGER NOT NULL,
    ->     TEAMNO INTEGER NOT NULL,
    ->     PLAYERNO INTEGER NOT NULL,
    ->     WON SMALLINT NOT NULL,
    ->     LOST SMALLINT NOT NULL,
    ->     PRIMARY KEY (MATCHNO)
    -> );
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> INSERT INTO MATCHES VALUES (1, 1, 6, 3, 1);
Query OK, 1 row affected (0.00 sec)

mysql> INSERT INTO MATCHES VALUES (4, 1, 44, 3, 2);
Query OK, 1 row affected (0.00 sec)

mysql>
mysql>
mysql> SELECT MATCHNO, TEAMNO, MATCHNO | TEAMNO,
    -> MATCHNO & TEAMNO, MATCHNO ^ TEAMNO
    -> FROM MATCHES;
+---------+--------+------------------+------------------+------------------+
| MATCHNO | TEAMNO | MATCHNO | TEAMNO | MATCHNO & TEAMNO | MATCHNO ^ TEAMNO |
+---------+--------+------------------+------------------+------------------+
|       1 |      1 |                1 |                1 |                0 |
|       4 |      1 |                5 |                0 |                5 |
+---------+--------+------------------+------------------+------------------+
2 rows in set (0.00 sec)

mysql>
mysql>
mysql> drop table matches;
Query OK, 0 rows affected (0.00 sec)

mysql>








Related examples in the same category

1.UPDATE statement moves each bit to the left one position:
2.left shift operator
3.The >> is the right shift operator
4.Bitwise operators
5.Bit Operators
6.Bit operation
7.Bit or
8.Left shift
9.Left shift 3
10.The result of a bitwise AND between 7 and 9 is 1
11.Shifting beyond 64 bits, or with a negative number, just returns 0.
12.Move the binary value 11 three bits to the left.