Yurttas/PL/DBL/mysql/F/01/00/bank/BankOne/Branch-ins.sql
Jump to navigation
Jump to search
1/*
2REM
3REM
4REM Branch-ins.sql
5REM
6REM
7*/
8
9\. set-db.sql
10
11INSERT INTO Branch
12 VALUES('Downtown', 9000000, 'Brooklyn');
13
14INSERT INTO Branch
15 VALUES('Redwood', 2100000, 'Palo Alto');
16
17INSERT INTO Branch
18 VALUES('Perryridge', 1700000, 'Horseneck');
19
20INSERT INTO Branch
21 VALUES('Mianus', 400000, 'Horseneck');
22
23INSERT INTO Branch
24 VALUES('Round Hill', 8000000, 'Horseneck');
25
26INSERT INTO Branch
27 VALUES('Pownal', 300000, 'Bennington');
28
29INSERT INTO Branch
30 VALUES('North Town', 3700000, 'Rye');
31
32INSERT INTO Branch
33 VALUES('Brighton', 7100000, 'Brooklyn');
34
35INSERT INTO Branch
36 VALUES('Hearne', 600000, 'Hearne');
37
38INSERT INTO Branch
39 VALUES('Caldwell', 800000, 'Caldwell');