banner

Discovery Project 7-1: Signs and Presidents

mysql> CREATE TABLE zodiacsigns (Sign VARCHAR(10),
    -> President VARCHAR(75));
Query OK, 0 rows affected (0.03 sec)

mysql> DESCRIBE zodiacsigns;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| Sign      | varchar(10) | YES  |     | NULL    |       | 
| President | varchar(75) | YES  |     | NULL    |       | 
+-----------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> INSERT into zodiacsigns (Sign, President)
    -> VALUES ('Rat', 'George Washington');
Query OK, 1 row affected (0.00 sec)

mysql> select * from zodiacsigns;
+------+-------------------+
| Sign | President         |
+------+-------------------+
| Rat  | George Washington | 
+------+-------------------+
1 row in set (0.00 sec)

mysql> INSERT into zodiacsigns (Sign, President)
    -> VALUES ('Ox', 'Barack Obama'), ('Tiger', 'Dwight Eisenhower');
Query OK, 2 rows affected (0.00 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> select * from zodiacsigns;
+-------+-------------------+
| Sign  | President         |
+-------+-------------------+
| Rat   | George Washington | 
| Ox    | Barack Obama      | 
| Tiger | Dwight Eisenhower | 
+-------+-------------------+
3 rows in set (0.00 sec)

mysql> INSERT into zodiacsigns (Sign, President)
    -> VALUES ('Rabbit', 'John Adams'), ('Dragon', 'Abraham Lincoln'), 
    -> ('Snake', 'John Kennedy'), ('Horse', 'Theodore Roosevelt');
Query OK, 4 rows affected (0.00 sec)
Records: 4  Duplicates: 0  Warnings: 0

mysql> INSERT into zodiacsigns (Sign, President)
    -> VALUES ('Goat', 'James Madison'), ('Monkey', 'Harry Truman'),
    -> ('Rooster', 'Grover Cleveland'), ('Dog', 'George W. Bush'),
    -> ('Pig', 'Ronald Reagan');
Query OK, 5 rows affected (0.00 sec)
Records: 5  Duplicates: 0  Warnings: 0

mysql> select * from zodiacsigns;
+---------+--------------------+
| Sign    | President          |
+---------+--------------------+
| Rat     | George Washington  | 
| Ox      | Barack Obama       | 
| Tiger   | Dwight Eisenhower  | 
| Rabbit  | John Adams         | 
| Dragon  | Abraham Lincoln    | 
| Snake   | John Kennedy       | 
| Horse   | Theodore Roosevelt | 
| Goat    | James Madison      | 
| Monkey  | Harry Truman       | 
| Rooster | Grover Cleveland   | 
| Dog     | George W. Bush     | 
| Pig     | Ronald Reagan      | 
+---------+--------------------+
12 rows in set (0.01 sec)

mysql>