Yurttas/PL/DBL/mysql/F/01/00/SPJ/Projects-ins.sql
Revision as of 16:36, 3 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM REM Projects-ins.sql REM REM: \. set-db.sql INSERT INTO Projects VALUES('J01', 'Monitor', 'Boston'); ...")
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');