Yurttas/PL/DBL/mysql-f-2010/01/BankTwo/Branch-ins.sql

From ZCubes Wiki
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('Hearne', 600000, 'Hearne');
16
17INSERT INTO Branch 
18  VALUES('Perryridge', 1700000, 'Horseneck');
19
20INSERT INTO Branch 
21  VALUES('Navasota', 400000, 'Navasota');
22
23INSERT INTO Branch 
24  VALUES('Caldwell', 800000, 'Caldwell');
25
26INSERT INTO Branch 
27  VALUES('Huntsville', 300000, 'Huntsville');
28
29INSERT INTO Branch 
30  VALUES('Brighton', 7100000, 'Brooklyn');