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