Yurttas/PL/DBL/postgres/F/01/Movies/MovieExec-ins.sql
Revision as of 00:46, 5 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM REM MovieExec-ins.sql REM REM: SELECT current_schema(); SET search_path to "movies"; INSERT INTO MovieE...")
1/*
2REM
3REM
4REM MovieExec-ins.sql
5REM
6REM
7*/
8
9SELECT current_schema();
10SET search_path to "movies";
11
12INSERT INTO MovieExec
13 VALUES('Debbie Allen', 'Hollywood, CA', 3009, 100);
14
15INSERT INTO MovieExec
16 VALUES('John Hughes', 'Hollywood, CA', 276, 500);
17
18INSERT INTO MovieExec
19 VALUES('Brian Grazer', 'Hollywood, CA', 817, 750);
20
21INSERT INTO MovieExec
22 VALUES('Wendy Finerman', 'Hollywood, CA', 1212, 500);
23
24INSERT INTO MovieExec
25 VALUES('Peter Guber', 'Hollywood, CA', 1222, 800);
26
27INSERT INTO MovieExec
28 VALUES('Su Armstrong', 'Hollywood, CA', 3002, 400);
29
30INSERT INTO MovieExec
31 VALUES('Letty Aronson', 'Hollywood, CA', 413, 500);
32
33INSERT INTO MovieExec
34 VALUES('Patrick Cassavetti', 'Hollywood, CA', 789, 300);