Yurttas/PL/DBL/mysql-f-2010/01/SPJ/Parts-ins.sql
Revision as of 02:20, 4 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM REM Parts-ins.sql REM REM: \. set-db.sql INSERT INTO Parts VALUES('P01', 'Nut', 'Red', 12, 'Houston')...")
1/*
2REM
3REM
4REM Parts-ins.sql
5REM
6REM
7*/
8
9\. set-db.sql
10
11INSERT INTO Parts
12 VALUES('P01', 'Nut', 'Red', 12, 'Houston');
13
14INSERT INTO Parts
15 VALUES('P02', 'Nut', 'Blue', 18, 'Phoenix');
16
17INSERT INTO Parts
18 VALUES('P03', 'Cam', 'Blue', 22, 'Phoenix');
19
20INSERT INTO Parts
21 VALUES('P04', 'Cam', 'Red', 45, 'Atlanta');
22
23INSERT INTO Parts
24 VALUES('P05', 'Cam', 'Red', 18, 'Phoenix');
25
26INSERT INTO Parts
27 VALUES('P06', 'Cam', 'Yellow', 19, 'Phoenix');
28
29INSERT INTO Parts
30 VALUES('P07', 'Cog', 'Red', 59, 'Houston');
31
32INSERT INTO Parts
33 VALUES('P08', 'Cog', 'Red', 46, 'Houston');
34
35INSERT INTO Parts
36 VALUES('P09', 'Nut', 'Red', 22, 'Phoenix');
37
38INSERT INTO Parts
39 VALUES('P10', 'Nut', 'Yellow', 59, 'Houston');
40
41INSERT INTO Parts
42 VALUES('P11', 'Cam', 'Blue', 17, 'Atlanta');
43
44INSERT INTO Parts
45 VALUES('P12', 'Cog', 'Blue', 24, 'Atlanta');