Yurttas/PL/DBL/mysql-f-2010/01/SPJ/Shipments-ins.sql
Revision as of 02:21, 4 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM REM Shipments-ins.sql REM REM: \. set-db.sql INSERT INTO Shipments VALUES('S01', 'P01', 'J01', 100); ...")
1/*
2REM
3REM
4REM Shipments-ins.sql
5REM
6REM
7*/
8
9\. set-db.sql
10
11INSERT INTO Shipments
12 VALUES('S01', 'P01', 'J01', 100);
13
14INSERT INTO Shipments
15 VALUES('S01', 'P01', 'J03', 200);
16
17INSERT INTO Shipments
18 VALUES('S01', 'P01', 'J04', 200);
19
20INSERT INTO Shipments
21 VALUES('S01', 'P01', 'J07', 200);
22
23INSERT INTO Shipments
24 VALUES('S01', 'P01', 'J08', 400);
25
26INSERT INTO Shipments
27 VALUES('S01', 'P01', 'J09', 300);
28
29INSERT INTO Shipments
30 VALUES('S01', 'P01', 'J10', 200);
31
32INSERT INTO Shipments
33 VALUES('S01', 'P02', 'J01', 200);
34
35INSERT INTO Shipments
36 VALUES('S01', 'P02', 'J02', 400);
37
38INSERT INTO Shipments
39 VALUES('S01', 'P03', 'J01', 200);
40
41INSERT INTO Shipments
42 VALUES('S01', 'P05', 'J02', 100);
43
44INSERT INTO Shipments
45 VALUES('S01', 'P06', 'J10', 100);
46
47INSERT INTO Shipments
48 VALUES('S02', 'P01', 'J01', 200);
49
50INSERT INTO Shipments
51 VALUES('S02', 'P01', 'J02', 200);
52
53INSERT INTO Shipments
54 VALUES('S02', 'P02', 'J01', 300);
55
56INSERT INTO Shipments
57 VALUES('S02', 'P04', 'J01', 500);
58
59INSERT INTO Shipments
60 VALUES('S03', 'P01', 'J01', 100);
61
62INSERT INTO Shipments
63 VALUES('S03', 'P02', 'J01', 100);
64
65INSERT INTO Shipments
66 VALUES('S03', 'P02', 'J02', 200);
67
68INSERT INTO Shipments
69 VALUES('S03', 'P02', 'J03', 200);
70
71INSERT INTO Shipments
72 VALUES('S03', 'P02', 'J04', 200);
73
74INSERT INTO Shipments
75 VALUES('S03', 'P02', 'J05', 200);
76
77INSERT INTO Shipments
78 VALUES('S03', 'P02', 'J06', 100);
79
80INSERT INTO Shipments
81 VALUES('S03', 'P02', 'J07', 200);
82
83INSERT INTO Shipments
84 VALUES('S03', 'P02', 'J08', 400);
85
86INSERT INTO Shipments
87 VALUES('S03', 'P02', 'J09', 300);
88
89INSERT INTO Shipments
90 VALUES('S03', 'P02', 'J10', 200);
91
92INSERT INTO Shipments
93 VALUES('S03', 'P02', 'J11', 200);
94
95INSERT INTO Shipments
96 VALUES('S04', 'P02', 'J03', 200);
97
98INSERT INTO Shipments
99 VALUES('S05', 'P01', 'J01', 200);
100
101INSERT INTO Shipments
102 VALUES('S05', 'P06', 'J04', 200);
103
104INSERT INTO Shipments
105 VALUES('S05', 'P07', 'J04', 200);
106
107INSERT INTO Shipments
108 VALUES('S06', 'P01', 'J04', 200);
109
110INSERT INTO Shipments
111 VALUES('S06', 'P01', 'J11', 200);
112
113INSERT INTO Shipments
114 VALUES('S07', 'P03', 'J02', 100);