Yurttas/PL/DBL/postgres/F/01/Movies/Studio-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 Studio-ins.sql REM REM: SELECT current_schema(); SET search_path to "movies"; INSERT INTO Studio ...")
1/*
2REM
3REM
4REM Studio-ins.sql
5REM
6REM
7*/
8
9SELECT current_schema();
10SET search_path to "movies";
11
12INSERT INTO Studio
13 VALUES('DreamWorks SKG', 'Hollywood, CA', 3009);
14
15INSERT INTO Studio
16 VALUES('Disney', 'Hollywood, CA', 276);
17
18INSERT INTO Studio
19 VALUES('MCA/Universal Pictures', 'Hollywood, CA', 817);
20
21INSERT INTO Studio
22 VALUES('Paramount', 'Hollywood, CA', 1212);
23
24INSERT INTO Studio
25 VALUES('Warner Bros.', 'Hollywood, CA', 1222);
26
27INSERT INTO Studio
28 VALUES('Be Gentlemen Limited Partnership', 'Hollywood, CA', 3002);
29
30INSERT INTO Studio
31 VALUES('Miramax', 'Hollywood, CA', 413);
32
33INSERT INTO Studio
34 VALUES('Haft Entertainment', 'Hollywood, CA', 789);