INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (6, "Cameron","James",1954) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (3, "Hitchcock","Alfred",1899) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (4, "Scott","Ridley",1937) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (5, "Weaver","Sigourney",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (8, "Winslett","Kate",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (9, "Tarkovski","Andrei",1932) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (10, "Woo","John",1946) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (11, "Travolta","John",1954) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (12, "Cage","Nicolas",1964) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (13, "Burton","Tim",1958) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (14, "Depp","Johnny",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (15, "Stewart","James",1908) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (16, "Novak","Kim",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (17, "Mendes","Sam",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (18, "Spacey","Kevin",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (19, "Bening","Anette",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (20, "Eastwood","Clint",1930) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (21, "Hackman","Gene",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (22, "Freeman","Morgan",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (23, "Crowe","Russell",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (24, "Ford","Harrison",1942) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (25, "Hauer","Rutger",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (26, "McTierman","John",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (27, "Willis","Bruce",1955) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (28, "Harlin","Renny",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (29, "Pialat","Maurice",1925) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (30, "Dutronc","Jacques",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (31, "Fincher","David",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (32, "Pitt","Brad",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (33, "Gilliam","Terry",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (34, "Annaud","Jean-Jacques",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (35, "Connery","Sean",1930) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (36, "Slater","Christian",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (37, "Tarantino","Quentin",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (38, "Jackson","Samuel L.",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (39, "Arquette","Rosanna",1959) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (40, "Thurman","Uma",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (41, "Farrelly","Bobby",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (42, "Diaz","Cameron",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (43, "Dillon","Mat",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (44, "Schwartzenegger","Arnold",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (45, "Spielberg","Steven",1946) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (46, "Sheider","Roy",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (47, "Shaw","Robert",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (48, "Dreyfus","Richard",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (49, "Demme","Jonathan",1944) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (50, "Hopkins","Anthony",1937) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (51, "Foster","Jodie",1962) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (52, "Chapman","Brenda",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (53, "Kilmer","Val",1959) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (54, "Fiennes","Ralph",1962) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (55, "Pfeiffer","Michelle",1957) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (56, "Bullock","Sandra",1964) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (57, "Goldblum","Jeff",1952) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (58, "Emmerich","Roland",1955) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (59, "Broderick","Matthew",1962) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (60, "Reno","Jean",1948) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (61, "Wachowski","Andy",1967) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (62, "Reeves","Keanu",1964) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (63, "Fishburne","Laurence",1961) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (64, "De Palma","Brian",1940) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (65, "Cruise","Tom",1962) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (66, "Voight","John",1938) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (67, "Béart","Emmanuelle",1965) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (68, "Kurozawa","Akira",1910) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (69, "Harris","Ed",1950) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (70, "Linney","Laura",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (71, "Girault","Jean",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (72, "De Funès","Louis",1914) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (73, "Galabru","Michel",1922) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (74, "Palud","Hervé",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (75, "Balasko","Josiane",1950) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (76, "Lavanant","Dominique",1944) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (77, "Lanvin","Gérard",1950) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (78, "Villeret","Jacques",1951) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (79, "Levinson","Barry",1942) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (80, "Hoffman","Dustin",1937) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (81, "Scott","Tony",1944) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (82, "McGillis","Kelly",1957) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (83, "Leconte","Patrice",1947) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (84, "Blanc","Michel",1952) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (85, "Clavier","Christian",1952) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (86, "Lhermite","Thierry",1952) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (87, "Pernnou","Marie",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (88, "Perkins","Anthony",1932) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (89, "Miles","Vera",1929) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (90, "Leigh","Janet",1927) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (91, "Marquand","Richard",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (92, "Hamill","Mark",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (93, "Fisher","Carrie",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (94, "Taylor","Rod",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (95, "Hedren","Tippi",1931) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (96, "Ricci","Christina",1980) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (97, "Walken","Christopher",1943) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (98, "Keitel","Harvey",1939) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (99, "Roth","Tim",1961) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (100, "Penn","Chris",1966) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (101, "Kubrick","Stanley",1928) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (102, "Kidman","Nicole",1967) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (103, "Nicholson","Jack",1937) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (104, "Kelly","Grace",1929) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (105, "Grant","Cary",1904) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (106, "Saint","Eva Marie",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (107, "Mason","James",1909) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (110, "DiCaprio","Leonardo",1974) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (109, "Winslet","Kate",1975) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (111, "Besson","Luc",1959) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (112, "Jovovich","Milla",1975) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (113, "Dunaway","Fane",1941) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (114, "Malkovitch","John",1953) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (115, "Karyo","Tchéky",1953) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (116, "Oldman","Gary",1958) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (117, "Holm","Ian",1931) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (118, "Portman","Natalie",0000) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (119, "Parillaud","Anne",1960) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (120, "Anglade","Jean-Hughes",1955) ; INSERT INTO artistes (idArtiste, artnom, artprenom,anneenaiss) VALUES (121, "Barr","Jean-Marc",1960) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (1, 1958, "Drame","USA","3","Vertigo" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (2, 1979, "Science-fiction","USA","4","Alien" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (3, 1997, "Drame","USA","6","Titanic" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (4, 1986, "Drame","FR","9","Sacrifice" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (5, 1997, "Action","USA","10","Volte/Face" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (6, 1999, "Fantastique","USA","13","Sleepy Hollow" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (7, 1999, "Comédie","USA","17","American Beauty" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (8, 1992, "Western","USA","20","Impitoyable" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (9, 2000, "Drame","USA","4","Gladiator" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (10, 1982, "Action","USA","4","Blade Runner" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (11, 1988, "Action","USA","26","Piège de cristal" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (12, 1990, "Action","USA","28","58 minutes pour vivre" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (13, 1990, "Drame","FR","29","Van Gogh" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (14, 1995, "Policier","USA","31","Seven" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (15, 1995, "Science-fiction","USA","33","L'armée des douze singes" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (16, 1986, "Policier","FR","34","Le nom de la rose" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (17, 1994, "Action","USA","37","Pulp fiction" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (18, 1998, "Comédie","USA","41","Mary à tout prix" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (19, 1984, "Science-fiction","USA","6","Terminator" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (20, 1975, "Horreur","FR","45","Les dents de la mer" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (21, 1990, "Policier","USA","49","Le silence des agneaux" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (22, 1998, "Dessin animé","USA","52","Le prince d'Egypte" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (23, 1998, "Action","USA","58","Godzilla" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (24, 1999, "Science-fiction","USA","61","Matrix" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (25, 1996, "Action","USA","64","Mission: Impossible" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (26, 1980, "Guerre","JP","68","Kagemusha" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (27, 1997, "Policier","USA","20","Les pleins pouvoirs" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (28, 1978, "Comédie","FR","71","Le gendarme et les extra-terrestres" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (29, 1986, "Comédie","FR","74","Les frères pétards" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (30, 1997, "Horreur","USA","45","Le monde perdu" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (31, 1988, "Drame","USA","79","Rain Man" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (32, 1986, "Action","USA","81","Top Gun" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (33, 1979, "Comédie","FR","83","Les bronzés font du ski" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (34, 1996, "Documentaire","FR","87","MICROCOSMOS" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (35, 1960, "(non su)","USA","3","Psychose" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (36, 1983, "Science-fiction","USA","91","Le retour du Jedi" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (37, 1963, "Horreur","USA","3","Les oiseaux" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (38, 1992, "Policier","USA","37","Reservoir dogs" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (39, 1999, "(non su)","USA","101","Eyes Wide Shut" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (40, 1980, "Horreur","FR","101","Shining" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (41, 1964, "(non su)","USA","3","Pas de printemps pour Marnie" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (42, 1954, "Suspense","USA","3","Fenêtre sur cour" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (43, 1959, "Suspense","USA","3","La mort aux trousses" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (44, 1999, "Guerre","FR","111","Jeanne d'Arc" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (45, 1997, "Science-fiction","FR","111","Le cinquième élément" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (46, 1994, "Action","FR","111","Léon" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (47, 1990, "Thriller","FR","111","Nikita" ) ; INSERT INTO films (idFilm,annee, genre, pays, mes, titre) VALUES (48, 1988, "Drame","FR","111","Le grand bleu" ) ; # pour vérification : select * from films limit 10 ; select * from artistes limit 10 ;