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>