Untitled

mysql> DESC account;
+---------------+--------------+------+-----+---------+-------+
| Field         | Type         | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| accountNumber | varchar(100) | NO   | PRI | NULL    |       |
| branchName    | varchar(100) | YES  |     | NULL    |       |
| balance       | varchar(100) | YES  |     | NULL    |       |
+---------------+--------------+------+-----+---------+-------+
3 rows in set (0.01 sec)

mysql> insert into account values('A-101','Downtown',500);
Query OK, 1 row affected (0.07 sec)

mysql> insert into account values('A-102','Perryridge',400);
Query OK, 1 row affected (0.10 sec)

mysql> insert into account values('A-201','Brighton',900);
Query OK, 1 row affected (0.07 sec)

mysql> insert into account values('A-215','Mianus',700);
Query OK, 1 row affected (0.08 sec)

mysql> insert into account values('A-217','Brighton',750);
Query OK, 1 row affected (0.08 sec)

mysql> insert into account values('A-222','Redwood',700);
Query OK, 1 row affected (0.11 sec)

mysql> insert into account values('A-305','Round Hill',350);
Query OK, 1 row affected (0.12 sec)

mysql> select *from account;
+---------------+------------+---------+
| accountNumber | branchName | balance |
+---------------+------------+---------+
| A-101         | Downtown   | 500     |
| A-102         | Perryridge | 400     |
| A-201         | Brighton   | 900     |
| A-215         | Mianus     | 700     |
| A-217         | Brighton   | 750     |
| A-222         | Redwood    | 700     |
| A-305         | Round Hill | 350     |
+---------------+------------+---------+
7 rows in set (0.00 sec)

mysql> DESC branch;
+------------+--------------+------+-----+---------+-------+
| Field      | Type         | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| branchName | varchar(100) | NO   | PRI | NULL    |       |
| branchCity | varchar(100) | YES  |     | NULL    |       |
| assets     | varchar(100) | YES  |     | NULL    |       |
+------------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> insert into branch  values('Brighton','Brooklyn',7100000);
Query OK, 1 row affected (0.09 sec)

mysql> insert into branch  values('Doentown','Brooklyn',9000000);
Query OK, 1 row affected (0.07 sec)

mysql> insert into branch  values('Mianus','Horseneck',400000);
Query OK, 1 row affected (0.08 sec)

mysql> insert into branch  values('North Town','Rye',3700000);
Query OK, 1 row affected (0.09 sec)

mysql> insert into branch  values('Perryridge','Horseneck',170000);
Query OK, 1 row affected (0.08 sec)

mysql> insert into branch  values('Pownal','Bennington',30000);
Query OK, 1 row affected (0.13 sec)

mysql> insert into branch  values('REdwood','Palo Alto',21000);
Query OK, 1 row affected (0.10 sec)

mysql> insert into branch  values('Round Hill','Horseneck',21000000);
Query OK, 1 row affected (0.10 sec)

mysql> desc branch;
+------------+--------------+------+-----+---------+-------+
| Field      | Type         | Null | Key | Default | Extra |
+------------+--------------+------+-----+---------+-------+
| branchName | varchar(100) | NO   | PRI | NULL    |       |
| branchCity | varchar(100) | YES  |     | NULL    |       |
| assets     | varchar(100) | YES  |     | NULL    |       |
+------------+--------------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql> select *from branch;
+------------+------------+----------+
| branchName | branchCity | assets   |
+------------+------------+----------+
| Brighton   | Brooklyn   | 7100000  |
| Doentown   | Brooklyn   | 9000000  |
| Mianus     | Horseneck  | 400000   |
| North Town | Rye        | 3700000  |
| Perryridge | Horseneck  | 170000   |
| Pownal     | Bennington | 30000    |
| REdwood    | Palo Alto  | 21000    |
| Round Hill | Horseneck  | 21000000 |
+------------+------------+----------+
8 rows in set (0.00 sec)