Yurttas/PL/DBL/postgres/F/01/SPJ/Parts-ins.sql
Revision as of 00:54, 5 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: SELECT current_schema(); SET search_path to "spj"; INSERT INTO Parts VALUE...")
1/*
2REM
3REM
4REM Parts-ins.sql
5REM
6REM
7*/
8
9SELECT current_schema();
10SET search_path to "spj";
11
12INSERT INTO Parts
13 VALUES('P01', 'Nut', 'Red', 12, 'Houston');
14
15INSERT INTO Parts
16 VALUES('P02', 'Nut', 'Blue', 18, 'Phoenix');
17
18INSERT INTO Parts
19 VALUES('P03', 'Cam', 'Blue', 22, 'Phoenix');
20
21INSERT INTO Parts
22 VALUES('P04', 'Cam', 'Red', 45, 'Atlanta');
23
24INSERT INTO Parts
25 VALUES('P05', 'Cam', 'Red', 18, 'Phoenix');
26
27INSERT INTO Parts
28 VALUES('P06', 'Cam', 'Yellow', 19, 'Phoenix');
29
30INSERT INTO Parts
31 VALUES('P07', 'Cog', 'Red', 59, 'Houston');
32
33INSERT INTO Parts
34 VALUES('P08', 'Cog', 'Red', 46, 'Houston');
35
36INSERT INTO Parts
37 VALUES('P09', 'Nut', 'Red', 22, 'Phoenix');
38
39INSERT INTO Parts
40 VALUES('P10', 'Nut', 'Yellow', 59, 'Houston');
41
42INSERT INTO Parts
43 VALUES('P11', 'Cam', 'Blue', 17, 'Atlanta');
44
45INSERT INTO Parts
46 VALUES('P12', 'Cog', 'Blue', 24, 'Atlanta');