Yurttas/PL/DBL/mysql/F/01/00/PC/Product-ins.sql

 1/*
 2REM
 3REM
 4REM Product-ins.sql
 5REM
 6REM
 7*/
 8
 9\. set-db.sql
10
11INSERT INTO Product
12  VALUES('A', '1001', 'pc');
13
14INSERT INTO Product
15  VALUES('A', '1002', 'pc');
16
17INSERT INTO Product
18  VALUES('A', '1003', 'pc');
19
20INSERT INTO Product
21  VALUES('B', '1004', 'pc');
22
23INSERT INTO Product
24  VALUES('B', '1006', 'pc');
25
26INSERT INTO Product
27  VALUES('B', '3002', 'printer');
28
29INSERT INTO Product
30  VALUES('B', '3004', 'printer');
31
32INSERT INTO Product
33  VALUES('C', '1005', 'pc');
34
35INSERT INTO Product
36  VALUES('C', '1007', 'pc');
37
38INSERT INTO Product
39  VALUES('D', '1008', 'pc');
40
41INSERT INTO Product
42  VALUES('D', '1009', 'pc');
43
44INSERT INTO Product
45  VALUES('D', '1010', 'pc');
46
47INSERT INTO Product
48  VALUES('D', '2001', 'laptop');
49
50INSERT INTO Product
51  VALUES('D', '2002', 'laptop');
52
53INSERT INTO Product
54  VALUES('D', '2003', 'laptop');
55
56INSERT INTO Product
57  VALUES('D', '3001', 'printer');
58
59INSERT INTO Product
60  VALUES('D', '3003', 'printer');
61
62INSERT INTO Product
63  VALUES('E', '2004', 'laptop');
64
65INSERT INTO Product
66  VALUES('E', '2008', 'laptop');
67
68INSERT INTO Product
69  VALUES('F', '2005', 'laptop');
70
71INSERT INTO Product
72  VALUES('G', '2006', 'laptop');
73
74INSERT INTO Product
75  VALUES('G', '2007', 'laptop');
76
77INSERT INTO Product
78  VALUES('H', '3005', 'printer');
79
80INSERT INTO Product
81  VALUES('I', '3006', 'printer');