Yurttas/PL/DBL/mysql/F/01/00/SPJ/Projects-ins.sql

 1/*
 2REM
 3REM
 4REM Projects-ins.sql
 5REM
 6REM
 7*/
 8
 9\. set-db.sql
10
11INSERT INTO Projects
12  VALUES('J01', 'Monitor', 'Boston');
13
14INSERT INTO Projects
15  VALUES('J02', 'Monitor', 'Portland');
16
17INSERT INTO Projects
18  VALUES('J03', 'Monitor', 'Denver');
19
20INSERT INTO Projects
21  VALUES('J04', 'Monitor', 'Houston');
22
23INSERT INTO Projects
24  VALUES('J05', 'Monitor', 'Dallas');
25
26INSERT INTO Projects
27  VALUES('J06', 'Monitor', 'Phoenix');
28
29INSERT INTO Projects
30  VALUES('J07', 'Monitor', 'Detroit');
31
32INSERT INTO Projects
33  VALUES('J08', 'Monitor', 'New York');
34
35INSERT INTO Projects
36  VALUES('J09', 'Monitor', 'Philadelphia');
37
38INSERT INTO Projects
39  VALUES('J10', 'CD-ROM', 'Boston');
40
41INSERT INTO Projects
42  VALUES('J11', 'CD-ROM', 'Houston');
43
44INSERT INTO Projects
45  VALUES('J12', 'CD-ROM', 'Dallas');
46
47INSERT INTO Projects
48  VALUES('J13', 'CD-ROM', 'New York');
49
50INSERT INTO Projects
51  VALUES('J14', 'CD-ROM', 'Portland');