Yurttas/PL/DBL/mysql/F/01/00/bank/BankOne/Borrower-ins.sql
Revision as of 16:01, 3 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">ββREM REM REM Borrower-ins.sql REM REM: \. set-db.sql INSERT INTO Borrower VALUES('Downtown', 17, 'Jones', 100...")
1/*
2REM
3REM
4REM Borrower-ins.sql
5REM
6REM
7*/
8
9\. set-db.sql
10
11INSERT INTO Borrower
12 VALUES('Downtown', 17, 'Jones', 1000);
13
14INSERT INTO Borrower
15 VALUES('Redwood', 23, 'Smith', 2000);
16
17INSERT INTO Borrower
18 VALUES('Mianus', 93, 'Curry', 500);
19
20INSERT INTO Borrower
21 VALUES('Round Hill', 11, 'Turner', 900);
22
23INSERT INTO Borrower
24 VALUES('North Town', 16, 'Adams', 1300);
25
26INSERT INTO Borrower
27 VALUES('Downtown', 18, 'Johnson', 2000);
28
29INSERT INTO Borrower
30 VALUES('Perryridge', 25, 'Glenn', 2500);
31
32INSERT INTO Borrower
33 VALUES('Brighton', 10, 'Brooks', 2200);
34
35INSERT INTO Borrower
36 VALUES('Perryridge', 102, 'Hayes', 100);
37
38INSERT INTO Borrower
39 VALUES('Perryridge', 201, 'Williams', 300);
40
41INSERT INTO Borrower
42 VALUES('Hearne', 204, 'Elizabeth', 100);
43
44INSERT INTO Borrower
45 VALUES('Caldwell', 106, 'Jack', 300);
46
47INSERT INTO Borrower
48 VALUES('Caldwell', 110, 'Julie', 100);
49
50INSERT INTO Borrower
51 VALUES('Caldwell', 300, 'Margaret', 200);