Yurttas/PL/DBL/postgres/F/01/Movies/MovieStar-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 MovieStar-ins.sql REM REM: SELECT current_schema(); SET search_path to "movies"; INSERT INTO MovieS...")
1/*
2REM
3REM
4REM MovieStar-ins.sql
5REM
6REM
7*/
8
9SELECT current_schema();
10SET search_path to "movies";
11
12INSERT INTO MovieStar
13 VALUES('Djimon Hounsou', 'Paris FR', 'M', 1970);
14
15INSERT INTO MovieStar
16 VALUES('Anthony Hopkins', 'Port Talbort, Wales UK', 'M', 1937);
17
18INSERT INTO MovieStar
19 VALUES('Ming-Na Wen', NULL, 'F', NULL);
20
21INSERT INTO MovieStar
22 VALUES('Eddie Murphy', NULL, 'M', NULL);
23
24INSERT INTO MovieStar
25 VALUES('Tom Hanks', NULL, 'M', NULL);
26
27INSERT INTO MovieStar
28 VALUES('Ed Harris', NULL, 'M', NULL);
29
30INSERT INTO MovieStar
31 VALUES('Bill Paxton', NULL, 'M', NULL);
32
33INSERT INTO MovieStar
34 VALUES('Sally Field', NULL, 'F', NULL);
35
36INSERT INTO MovieStar
37 VALUES('Liam Neeson', NULL, 'M', NULL);
38
39INSERT INTO MovieStar
40 VALUES('Ben Kingsley', NULL, 'M', NULL);
41
42INSERT INTO MovieStar
43 VALUES('Danny Glover', NULL, 'M', NULL);
44
45INSERT INTO MovieStar
46 VALUES('Whoopi Goldberg', NULL, 'F', NULL);
47
48INSERT INTO MovieStar
49 VALUES('Robin Williams', NULL, 'M', NULL);
50
51INSERT INTO MovieStar
52 VALUES('Marcia Gay Harden', NULL, 'F', NULL);
53
54INSERT INTO MovieStar
55 VALUES('Mat Damon', NULL, 'M', NULL);
56
57INSERT INTO MovieStar
58 VALUES('John Cusak', NULL, 'M', NULL);
59
60INSERT INTO MovieStar
61 VALUES('Jack Warden', NULL, 'M', NULL);
62
63INSERT INTO MovieStar
64 VALUES('Gwyneth Paltrow', NULL, 'F', NULL);
65
66INSERT INTO MovieStar
67 VALUES('James Cosmo', NULL, 'M', NULL);