Yurttas/PL/DBL/mysql-f-2010/01/Bank/Borrower-ins.sql

Revision as of 01:41, 4 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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision β†’ (diff)
 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('Perryridge', 15, 'Hayes', 1500);
19
20INSERT INTO Borrower 
21  VALUES('Mianus', 93, 'Curry', 500);
22
23INSERT INTO Borrower 
24  VALUES('Round Hill', 11, 'Turner', 900);
25
26INSERT INTO Borrower 
27  VALUES('Pownal', 29, 'Williams', 1200);
28
29INSERT INTO Borrower 
30  VALUES('North Town', 16, 'Adams', 1300);
31
32INSERT INTO Borrower 
33  VALUES('Downtown', 18, 'Johnson', 2000);
34
35INSERT INTO Borrower 
36  VALUES('Perryridge', 25, 'Glenn', 2500);
37
38INSERT INTO Borrower 
39  VALUES('Brighton', 10, 'Brooks', 2200);