Yurttas/PL/DBL/postgres/F/01/PC/Laptop-ins.sql
Revision as of 23:48, 4 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM REM Laptop-ins.sql REM REM: SELECT current_schema(); SET search_path to "pc"; INSERT INTO Laptop VALU...")
1/*
2REM
3REM
4REM Laptop-ins.sql
5REM
6REM
7*/
8
9SELECT current_schema();
10SET search_path to "pc";
11
12INSERT INTO Laptop
13 VALUES('2001', 100, 20, 1.10, 9.5, 1999);
14
15INSERT INTO Laptop
16 VALUES('2002', 117, 12, 0.75, 11.3, 2499);
17
18INSERT INTO Laptop
19 VALUES('2003', 117, 32, 1.00, 10.4, 3599);
20
21INSERT INTO Laptop
22 VALUES('2004', 133, 16, 1.10, 11.2, 3499);
23
24INSERT INTO Laptop
25 VALUES('2005', 133, 16, 1.00, 11.3, 2599);
26
27INSERT INTO Laptop
28 VALUES('2006', 120, 8, 0.81, 12.1, 1999);
29
30INSERT INTO Laptop
31 VALUES('2007', 150, 16, 1.35, 12.1, 4799);
32
33INSERT INTO Laptop
34 VALUES('2008', 120, 16, 1.10, 12.1, 2099);