mysql>
mysql> CREATE TABLE pants
-> (
-> item CHAR(20)
-> );
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> SELECT * FROM pants;
Empty set (0.00 sec)
mysql>
mysql> INSERT INTO pants (item) VALUES('Plaid');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO pants (item) VALUES('Striped');
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO pants (item) VALUES('Corduroy');
Query OK, 1 row affected (0.00 sec)
mysql>
mysql> CREATE TABLE shirt (item CHAR(20));
Query OK, 0 rows affected (0.00 sec)
mysql> INSERT INTO shirt (item) VALUES('Pinstripe'),('Tie-Dye'),('Black');
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql>
mysql> CREATE TABLE tie (item CHAR(20));
Query OK, 0 rows affected (0.00 sec)
mysql> INSERT INTO tie (item) VALUES('Fleur de lis'),('Paisley'),('Polka Dot');
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql>
mysql>
mysql> SELECT s.item, t.item, p.item
-> FROM shirt AS s, tie AS t, pants AS p;
+-----------+--------------+----------+
| item | item | item |
+-----------+--------------+----------+
| Pinstripe | Fleur de lis | Plaid |
| Tie-Dye | Fleur de lis | Plaid |
| Black | Fleur de lis | Plaid |
| Pinstripe | Paisley | Plaid |
| Tie-Dye | Paisley | Plaid |
| Black | Paisley | Plaid |
| Pinstripe | Polka Dot | Plaid |
| Tie-Dye | Polka Dot | Plaid |
| Black | Polka Dot | Plaid |
| Pinstripe | Fleur de lis | Striped |
| Tie-Dye | Fleur de lis | Striped |
| Black | Fleur de lis | Striped |
| Pinstripe | Paisley | Striped |
| Tie-Dye | Paisley | Striped |
| Black | Paisley | Striped |
| Pinstripe | Polka Dot | Striped |
| Tie-Dye | Polka Dot | Striped |
| Black | Polka Dot | Striped |
| Pinstripe | Fleur de lis | Corduroy |
| Tie-Dye | Fleur de lis | Corduroy |
| Black | Fleur de lis | Corduroy |
| Pinstripe | Paisley | Corduroy |
| Tie-Dye | Paisley | Corduroy |
| Black | Paisley | Corduroy |
| Pinstripe | Polka Dot | Corduroy |
| Tie-Dye | Polka Dot | Corduroy |
| Black | Polka Dot | Corduroy |
+-----------+--------------+----------+
27 rows in set (0.00 sec)
mysql>
mysql> drop table pants;
Query OK, 0 rows affected (0.00 sec)
mysql> drop table shirt;
Query OK, 0 rows affected (0.00 sec)
mysql> drop table tie;
Query OK, 0 rows affected (0.00 sec)