nick@Vaxis:~$ ssh artemis Linux artemis 5.10.0-28-amd64 #1 SMP Debian 5.10.209-2 (2024-01-31) x86_64 The programs included with the Debian GNU/Linux system are free software; the exact distribution terms for each program are described in the individual files in /usr/share/doc/*/copyright. Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent permitted by applicable law. Last login: Wed Nov 20 13:19:25 2024 from 136.168.201.2 nick@artemis:~$ mysql movie_test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A BWelcome to the MariaDB monitor. Commands end with ; or \g. BBYour MariaDB connection id is 103992 Server version: 10.3.38-MariaDB-0+deb10u1 Debian 10 BBCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. BBType 'help;' or '\h' for help. Type '\c' to clear the current input statement. BMariaDB [movie_test]> show tables; +----------------------+ | Tables_in_movie_test | +----------------------+ | movie_genres | | movies | | ratings | +----------------------+ B3 rows in set (0.000 sec) BB BMariaDB [movie_test]> describe movie_genres; +---------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+-------------+------+-----+---------+-------+ | movieId | int(11) | NO | PRI | NULL | | | genre | varchar(50) | NO | PRI | NULL | | +---------+-------------+------+-----+---------+-------+ B2 rows in set (0.001 sec) BB BMariaDB [movie_test]> select count(*) from movie_genres; +----------+ | count(*) | +----------+ | 23107 | +----------+ B1 row in set (0.011 sec) BB BMariaDB [movie_test]> select count(*) from movies;enres; +----------+ | count(*) | +----------+ | 10329 | +----------+ B1 row in set (0.005 sec) BB BMariaDB [movie_test]> select distinct genre from movie_genres; +-------------+ | genre | +-------------+ | Action | | Adventure | | Animation | | Children | | Comedy | | Crime | | Documentary | | Drama | | Fantasy | | Film-Noir | | Horror | | IMAX | | Musical | | Mystery | | Romance | | Sci-Fi | | Thriller | | War | | Western | +-------------+ B19 rows in set (0.000 sec) BB ;selecttdistinctrgenreefromimovie_genres;fselectvdistinctsgenrelfromdmovie_genres; from movie_genres; BQuery OK, 19 rows affected (0.013 sec) BBRecords: 19 Duplicates: 0 Warnings: 0 BB BMariaDB [movie_test]> [1]+ Stopped mysql movie_test nick@artemis:~$ php -a Interactive mode enabled $ap=>array_fill(0, 5, "?"); $a);t_r(4a Array ( [0] => ? [1] => ? [2] => ? [3] => ? [4] => ? ) p", $a);ho implode(", ?, ?, ?, ?, ? php > exit nick@artemis:~$ fg mysql movie_test MariaDB [movie_test]> select * from movies -> where movieId in ( -> select movieId -> from movie_genres -> where genre IN ( "War" ) -> ) -> group by movieId -> having count(*) = 1; +---------+-----------------------------------------------------------------------------+------+-------------------------------------------------+ | movieId | title | year | genres | +---------+-----------------------------------------------------------------------------+------+-------------------------------------------------+ | 41 | Richard III (1995) | 1995 | Drama|War | | 73 | Misérables, Les (1995) | 1995 | Drama|War | | 110 | Braveheart (1995) | 1995 | Action|Drama|War | | 151 | Rob Roy (1995) | 1995 | Action|Drama|Romance|War | | 155 | Beyond Rangoon (1995) | 1995 | Adventure|Drama|War | | 157 | Canadian Bacon (1995) | 1995 | Comedy|War | | 161 | Crimson Tide (1995) | 1995 | Drama|Thriller|War | | 214 | Before the Rain (Pred dozhdot) (1994) | 1994 | Drama|War | | 266 | Legends of the Fall (1994) | 1994 | Drama|Romance|War|Western | | 336 | Walking Dead, The (1995) | 1995 | Drama|War | | 340 | War, The (1994) | 1994 | Adventure|Drama|War | | 356 | Forrest Gump (1994) | 1994 | Comedy|Drama|Romance|War | | 389 | Colonel Chabert, Le (1994) | 1994 | Drama|Romance|War | | 465 | Heaven & Earth (1993) | 1993 | Action|Drama|War | | 466 | Hot Shots! Part Deux (1993) | 1993 | Action|Comedy|War | | 473 | In the Army Now (1994) | 1994 | Comedy|War | | 527 | Schindler's List (1993) | 1993 | Drama|War | | 632 | Land and Freedom (Tierra y libertad) (1995) | 1995 | Drama|War | | 647 | Courage Under Fire (1996) | 1996 | Action|Crime|Drama|War | | 665 | Underground (1995) | 1995 | Comedy|Drama|War | | 688 | Operation Dumbo Drop (1995) | 1995 | Action|Adventure|Comedy|War | | 750 | Dr. Strangelove or: How I Learned to Stop Worrying and Love the Bomb (1964) | 1964 | Comedy|War | | 760 | Stalingrad (1993) | 1993 | Drama|War | | 897 | For Whom the Bell Tolls (1943) | 1943 | Adventure|Drama|Romance|War | | 920 | Gone with the Wind (1939) | 1939 | Drama|Romance|War | | 946 | To Be or Not to Be (1942) | 1942 | Comedy|Drama|War | | 966 | Walk in the Sun, A (1945) | 1945 | War | | 969 | African Queen, The (1951) | 1951 | Adventure|Comedy|Romance|War | | 976 | Farewell to Arms, A (1932) | 1932 | Romance|War | | 979 | Nothing Personal (1995) | 1995 | Drama|War | | 1071 | For the Moment (1994) | 1994 | Romance|War | | 1078 | Bananas (1971) | 1971 | Comedy|War | | 1090 | Platoon (1986) | 1986 | Drama|War | | 1161 | Tin Drum, The (Blechtrommel, Die) (1979) | 1979 | Drama|War | | 1178 | Paths of Glory (1957) | 1957 | Drama|War | | 1183 | English Patient, The (1996) | 1996 | Drama|Romance|War | | 1204 | Lawrence of Arabia (1962) | 1962 | Adventure|Drama|War | | 1208 | Apocalypse Now (1979) | 1979 | Action|Drama|War | | 1217 | Ran (1985) | 1985 | Drama|War | | 1222 | Full Metal Jacket (1987) | 1987 | Drama|War | | 1224 | Henry V (1989) | 1989 | Action|Drama|Romance|War | | 1233 | Boot, Das (Boat, The) (1981) | 1981 | Action|Drama|War | | 1242 | Glory (1989) | 1989 | Drama|War | | 1250 | Bridge on the River Kwai, The (1957) | 1957 | Adventure|Drama|War | | 1256 | Duck Soup (1933) | 1933 | Comedy|Musical|War | | 1262 | Great Escape, The (1963) | 1963 | Action|Adventure|Drama|War | | 1263 | Deer Hunter, The (1978) | 1978 | Drama|War | | 1267 | Manchurian Candidate, The (1962) | 1962 | Crime|Thriller|War | | 1272 | Patton (1970) | 1970 | Drama|War | | 1281 | Great Dictator, The (1940) | 1940 | Comedy|Drama|War | | 1299 | Killing Fields, The (1984) | 1984 | Drama|War | | 1398 | In Love and War (1996) | 1996 | Romance|War | | 1408 | Last of the Mohicans, The (1992) | 1992 | Action|Romance|War|Western | | 1445 | McHale's Navy (1997) | 1997 | Comedy|War | | 1450 | Prisoner of the Mountains (Kavkazsky plennik) (1996) | 1996 | War | | 1616 | Peacemaker, The (1997) | 1997 | Action|Thriller|War | | 1619 | Seven Years in Tibet (1997) | 1997 | Adventure|Drama|War | | 1663 | Stripes (1981) | 1981 | Comedy|War | | 1670 | Welcome to Sarajevo (1997) | 1997 | Drama|War | | 1696 | Bent (1997) | 1997 | Drama|War | | 1873 | Misérables, Les (1998) | 1998 | Crime|Drama|Romance|War | | 1920 | Small Soldiers (1998) | 1998 | Animation|Children|Fantasy|War | | 1925 | Wings (1927) | 1927 | Action|Drama|Romance|War | | 1927 | All Quiet on the Western Front (1930) | 1930 | Action|Drama|War | | 1936 | Mrs. Miniver (1942) | 1942 | Drama|War | | 1939 | Best Years of Our Lives, The (1946) | 1946 | Drama|War | | 1944 | From Here to Eternity (1953) | 1953 | Drama|Romance|War | | 2028 | Saving Private Ryan (1998) | 1998 | Action|Drama|War | | 2067 | Doctor Zhivago (1965) | 1965 | Drama|Romance|War | | 2075 | Mephisto (1981) | 1981 | Drama|War | | 2106 | Swing Kids (1993) | 1993 | Drama|War | | 2202 | Lifeboat (1944) | 1944 | Drama|War | | 2322 | Soldier (1998) | 1998 | Action|Sci-Fi|War | | 2324 | Life Is Beautiful (La Vita è bella) (1997) | 1997 | Comedy|Drama|Romance|War | | 2358 | Savior (1998) | 1998 | Drama|War | | 2404 | Rambo III (1988) | 1988 | Action|Adventure|Thriller|War | | 2427 | Thin Red Line, The (1998) | 1998 | Action|Drama|War | | 2436 | Tea with Mussolini (1999) | 1999 | Comedy|Drama|War | | 2476 | Heartbreak Ridge (1986) | 1986 | Action|War | | 2669 | Pork Chop Hill (1959) | 1959 | War | | 2670 | Run Silent Run Deep (1958) | 1958 | War | | 2728 | Spartacus (1960) | 1960 | Action|Drama|Romance|War | | 2730 | Barry Lyndon (1975) | 1975 | Drama|Romance|War | | 2815 | Iron Eagle (1986) | 1986 | Action|War | | 2816 | Iron Eagle II (1988) | 1988 | Action|War | | 2818 | Iron Eagle IV (1995) | 1995 | Action|War | | 2833 | Lucie Aubrac (1997) | 1997 | Romance|War | | 2890 | Three Kings (1999) | 1999 | Action|Adventure|Comedy|Drama|War | | 2919 | Year of Living Dangerously, The (1982) | 1982 | Drama|Romance|War | | 2941 | South Pacific (1958) | 1958 | Musical|Romance|War | | 2944 | Dirty Dozen, The (1967) | 1967 | Action|Drama|War | | 2972 | Red Sorghum (Hong gao liang) (1987) | 1987 | Drama|War | | 3003 | Train of Life (Train de vie) (1998) | 1998 | Comedy|Drama|Romance|War | | 3022 | General, The (1926) | 1926 | Comedy|War | | 3035 | Mister Roberts (1955) | 1955 | Comedy|Drama|War | | 3049 | How I Won the War (1967) | 1967 | Comedy|War | | 3053 | Messenger: The Story of Joan of Arc, The (1999) | 1999 | Drama|War | | 3062 | Longest Day, The (1962) | 1962 | Action|Drama|War | | 3066 | Tora! Tora! Tora! (1970) | 1970 | Action|Drama|War | | 3091 | Kagemusha (1980) | 1980 | Drama|War | | 3117 | Ride with the Devil (1999) | 1999 | Drama|Romance|War | | 3134 | Grand Illusion (La grande illusion) (1937) | 1937 | Drama|War | | 3137 | Sea Wolves, The (1980) | 1980 | Action|War | | 3143 | Hell in the Pacific (1968) | 1968 | Drama|War | | 3196 | Stalag 17 (1953) | 1953 | Drama|War | | 3339 | Cross of Iron (1977) | 1977 | War | | 3342 | Birdy (1984) | 1984 | Drama|War | | 3372 | Bridge at Remagen, The (1969) | 1969 | Action|War | | 3377 | Hangmen Also Die (1943) | 1943 | Drama|War | | 3406 | Captain Horatio Hornblower R.N. (1951) | 1951 | Action|Adventure|Drama|War | | 3414 | Love Is a Many-Splendored Thing (1955) | 1955 | Drama|Romance|War | | 3441 | Red Dawn (1984) | 1984 | Action|Drama|War | | 3448 | Good Morning, Vietnam (1987) | 1987 | Comedy|Drama|War | | 3519 | Force 10 from Navarone (1978) | 1978 | Action|Drama|War | | 3555 | U-571 (2000) | 2000 | Action|Thriller|War | | 3585 | Great Locomotive Chase, The (1956) | 1956 | Adventure|War | | 3628 | Flying Tigers (1942) | 1942 | Action|Drama|Romance|War | | 3643 | Fighting Seabees, The (1944) | 1944 | Action|Drama|War | | 3654 | Guns of Navarone, The (1961) | 1961 | Action|Adventure|Drama|War | | 3670 | Story of G.I. Joe (1945) | 1945 | War | | 3724 | Coming Home (1978) | 1978 | Drama|War | | 3742 | Battleship Potemkin (1925) | 1925 | Drama|War | | 3753 | Patriot, The (2000) | 2000 | Action|Drama|War | | 3766 | Missing in Action (1984) | 1984 | Action|War | | 3767 | Missing in Action 2: The Beginning (1985) | 1985 | Action|War | | 3768 | Braddock: Missing in Action III (1988) | 1988 | Action|War | | 3808 | Two Women (Ciociara, La) (1960) | 1960 | Drama|War | | 3811 | Breaker Morant (1980) | 1980 | Drama|War | | 3836 | Kelly's Heroes (1970) | 1970 | Action|Comedy|War | | 3985 | Eagle Has Landed, The (1976) | 1976 | Drama|War | | 3992 | Malèna (2000) | 2000 | Drama|Romance|War | | 4008 | Born on the Fourth of July (1989) | 1989 | Drama|War | | 4033 | Thirteen Days (2000) | 2000 | Drama|Thriller|War | | 4042 | Alamo, The (1960) | 1960 | Action|Drama|War|Western | | 4047 | Gettysburg (1993) | 1993 | Drama|War | | 4103 | Empire of the Sun (1987) | 1987 | Action|Adventure|Drama|War | | 4111 | Gardens of Stone (1987) | 1987 | Drama|War | | 4194 | I Know Where I'm Going! (1945) | 1945 | Drama|Romance|War | | 4207 | Navy Seals (1990) | 1990 | Action|Adventure|War | | 4223 | Enemy at the Gates (2001) | 2001 | Drama|War | | 4310 | Pearl Harbor (2001) | 2001 | Action|Drama|Romance|War | | 4323 | Horse Soldiers, The (1959) | 1959 | Adventure|War|Western | | 4337 | Sand Pebbles, The (1966) | 1966 | Drama|Romance|War | | 4338 | Twelve O'Clock High (1949) | 1949 | Drama|War | | 4339 | Von Ryan's Express (1965) | 1965 | Action|Adventure|Drama|War | | 4349 | Catch-22 (1970) | 1970 | Comedy|War | | 4353 | Uncommon Valor (1983) | 1983 | Action|War | | 4407 | Salvador (1986) | 1986 | Drama|Thriller|War | | 4473 | Bat*21 (1988) | 1988 | Drama|War | | 4475 | Beast of War, The (Beast, The) (1988) | 1988 | Drama|War | | 4528 | Off Limits (1988) | 1988 | Action|Thriller|War | | 4577 | Casualties of War (1989) | 1989 | Drama|War | | 4594 | Farewell to the King (1989) | 1989 | Action|War | | 4727 | Captain Corelli's Mandolin (2001) | 2001 | Drama|Romance|War | | 4795 | Father Goose (1964) | 1964 | Adventure|Comedy|Romance|War | | 4802 | Operation Petticoat (1959) | 1959 | Action|Comedy|Romance|War | | 4826 | Big Red One, The (1980) | 1980 | Action|Adventure|Drama|War | | 4842 | Dogs of War, The (1980) | 1980 | Drama|War | | 4902 | Devil's Backbone, The (Espinazo del diablo, El) (2001) | 2001 | Drama|Fantasy|Horror|Thriller|War | | 4916 | Midway (1976) | 1976 | Drama|War | | 4918 | Young Lions, The (1958) | 1958 | Drama|War | | 4934 | Exterminator, The (1980) | 1980 | Action|Crime|Thriller|War | | 4958 | Behind Enemy Lines (2001) | 2001 | Action|Drama|War | | 4967 | No Man's Land (2001) | 2001 | Drama|War | | 5001 | Sahara (1943) | 1943 | Action|Drama|War | | 5010 | Black Hawk Down (2001) | 2001 | Action|Drama|War | | 5060 | M*A*S*H (a.k.a. MASH) (1970) | 1970 | Comedy|Drama|War | | 5107 | Hart's War (2002) | 2002 | Drama|War | | 5115 | Cast a Giant Shadow (1966) | 1966 | Adventure|War | | 5152 | We Were Soldiers (2002) | 2002 | Action|Drama|War | | 5288 | Atomic Cafe, The (1982) | 1982 | Documentary|War | | 5304 | Rome, Open City (a.k.a. Open City) (Roma, città aperta) (1945) | 1945 | Drama|War | | 5368 | Ballad of a Soldier (Ballada o soldate) (1959) | 1959 | Drama|Romance|War | | 5373 | Cranes Are Flying, The (Letyat zhuravli) (1957) | 1957 | Drama|Romance|War | | 5406 | Desert Rats, The (1953) | 1953 | Drama|War | | 5420 | Windtalkers (2002) | 2002 | Action|Drama|War | | 5425 | Dark Blue World (Tmavomodrý svet) (2001) | 2001 | Drama|War | | 5541 | Hot Shots! (1991) | 1991 | Action|Comedy|Romance|War | | 5611 | Four Feathers, The (2002) | 2002 | Adventure|War | | 5651 | Incredible Mr. Limpet, The (1964) | 1964 | Animation|Comedy|War | | 5686 | Russian Ark (Russkiy Kovcheg) (2002) | 2002 | Drama|Fantasy|War | | 5690 | Grave of the Fireflies (Hotaru no haka) (1988) | 1988 | Animation|Drama|War | | 5747 | Gallipoli (1981) | 1981 | Drama|War | | 5799 | Exodus (1960) | 1960 | Drama|Romance|War | | 5801 | Russians Are Coming, the Russians Are Coming, The (1966) | 1966 | Comedy|War | | 5817 | Ararat (2002) | 2002 | Drama|War | | 5825 | Life and Death of Colonel Blimp, The (1943) | 1943 | Drama|Romance|War | | 5859 | Southern Comfort (1981) | 1981 | Drama|Thriller|War | | 5876 | Quiet American, The (2002) | 2002 | Drama|Thriller|War | | 5899 | Zulu (1964) | 1964 | Action|Drama|War | | 5915 | Victory (a.k.a. Escape to Victory) (1981) | 1981 | Action|Drama|War | | 5965 | Duellists, The (1977) | 1977 | Action|War | | 5975 | War and Peace (1956) | 1956 | Drama|Romance|War | | 5995 | Pianist, The (2002) | 2002 | Drama|War | | 6017 | Divine Intervention (Yadon ilaheyya) (2002) | 2002 | Comedy|Drama|Romance|War | | 6107 | Night of the Shooting Stars (Notte di San Lorenzo, La) (1982) | 1982 | Drama|War | | 6117 | Privates on Parade (1982) | 1982 | Comedy|Drama|War | | 6181 | Red Badge of Courage, The (1951) | 1951 | Drama|War | | 6186 | Gods and Generals (2003) | 2003 | Action|Drama|War | | 6235 | Europa Europa (Hitlerjunge Salomon) (1990) | 1990 | Drama|War | | 6263 | Basic (2003) | 2003 | Drama|Thriller|War | | 6388 | Regeneration (1997) | 1997 | Drama|War | | 6401 | Rio Lobo (1970) | 1970 | Adventure|Romance|War|Western | | 6416 | King Rat (1965) | 1965 | Drama|War | | 6422 | Shenandoah (1965) | 1965 | Drama|War|Western | | 6428 | Two Mules for Sister Sara (1970) | 1970 | Comedy|War|Western | | 6431 | Battle Cry (1955) | 1955 | Drama|War | | 6434 | Objective, Burma! (1945) | 1945 | War | | 6437 | 13 Rue Madeleine (1947) | 1947 | Thriller|War | | 6439 | Attack! (1956) | 1956 | Drama|War | | 6441 | Battle of Britain (1969) | 1969 | War | | 6447 | Duel at Diablo (1966) | 1966 | War | | 6450 | Heaven Knows, Mr. Allison (1957) | 1957 | Drama|War | | 6457 | Sink the Bismark! (1960) | 1960 | Action|Drama|War | | 6458 | Blue Max, The (1966) | 1966 | Adventure|Drama|War | | 6459 | Desert Fox, The (1951) | 1951 | Drama|War | | 6497 | Is Paris Burning? (Paris brûle-t-il?) (1966) | 1966 | Drama|War | | 6518 | Flight of the Intruder (1991) | 1991 | Action|War | | 6561 | Mouse That Roared, The (1959) | 1959 | Comedy|War | | 6567 | Buffalo Soldiers (2001) | 2001 | Comedy|Crime|Drama|War | | 6672 | War Photographer (2001) | 2001 | Documentary|War | | 6682 | Earth (1998) | 1998 | Drama|War | | 6808 | Where Eagles Dare (1968) | 1968 | Action|Adventure|War | | 6818 | Come and See (Idi i smotri) (1985) | 1985 | Drama|War | | 6854 | Bedford Incident, The (1965) | 1965 | Drama|Thriller|War | | 6886 | Beyond Borders (2003) | 2003 | Drama|Romance|War | | 6896 | Shoah (1985) | 1985 | Documentary|War | | 6923 | Sherlock Holmes and the Voice of Terror (1942) | 1942 | Crime|Mystery|War | | 6947 | Master and Commander: The Far Side of the World (2003) | 2003 | Adventure|Drama|War | | 6982 | Forbidden Games (Jeux interdits) (1952) | 1952 | Drama|War | | 7025 | Midnight Clear, A (1992) | 1992 | Drama|War | | 7065 | Birth of a Nation, The (1915) | 1915 | Drama|War | | 7104 | 1941 (1979) | 1979 | Comedy|War | | 7106 | Black and White in Color (Noirs et blancs en couleur) (1976) | 1976 | Drama|War | | 7118 | Wings of Honneamise (Ôritsu uchûgun Oneamisu no tsubasa) (1987) | 1987 | Animation|Drama|Sci-Fi|War | | 7122 | King of Hearts (1966) | 1966 | Comedy|Drama|War | | 7143 | Last Samurai, The (2003) | 2003 | Action|Adventure|Drama|War | | 7156 | Fog of War: Eleven Lessons from the Life of Robert S. McNamara, The (2003) | 2003 | Documentary|War | | 7162 | Cold Mountain (2003) | 2003 | Drama|Romance|War | | 7214 | Kiss Them for Me (1957) | 1957 | Comedy|Romance|War | | 7215 | To Have and Have Not (1944) | 1944 | Adventure|Drama|Romance|Thriller|War | | 7238 | Ashes and Diamonds (Popiól i diament) (1958) | 1958 | Drama|War | | 7303 | The Diary of Anne Frank (1959) | 1959 | Drama|War | | 7307 | Flesh & Blood (1985) | 1985 | Action|Adventure|Drama|War | | 7338 | Richard III (1955) | 1955 | Drama|War | | 7379 | The Alamo (2004) | 2004 | Drama|War|Western | | 7458 | Troy (2004) | 2004 | Action|Adventure|Drama|War | | 7480 | Under Fire (1983) | 1983 | Drama|Thriller|War | | 7502 | Band of Brothers (2001) | 2001 | Action|Drama|War | | 7560 | Fail-Safe (1964) | 1964 | Drama|Thriller|War | | 7756 | Alexander Nevsky (Aleksandr Nevskiy) (1938) | 1938 | Action|Drama|War | | 7766 | Throne of Blood (Kumonosu jô) (1957) | 1957 | Action|Drama|Thriller|War | | 7809 | Ambush (Rukajärven tie) (1999) | 1999 | Drama|Romance|War | | 7828 | Rack, The (1956) | 1956 | Drama|War | | 7840 | Gunga Din (1939) | 1939 | Adventure|Comedy|War | | 7894 | Duck, You Sucker (a.k.a. Fistful of Dynamite, A) (Giù la testa) (1971) | 1971 | Action|Adventure|War|Western | | 7980 | Bridge Too Far, A (1977) | 1977 | Action|Drama|War | | 8045 | Hamburger Hill (1987) | 1987 | Action|Drama|War | | 8190 | Americanization of Emily, The (1964) | 1964 | Comedy|Drama|War | | 8197 | Hiroshima Mon Amour (1959) | 1959 | Drama|Romance|War | | 8227 | Drums Along the Mohawk (1939) | 1939 | Adventure|War|Western | | 8257 | Battleground (1949) | 1949 | Action|Drama|War | | 8337 | Caine Mutiny, The (1954) | 1954 | Drama|War | | 8446 | Sands of Iwo Jima (1949) | 1949 | Action|Drama|Romance|War | | 8493 | Memphis Belle (1990) | 1990 | Action|Drama|War | | 8540 | Back to Bataan (1945) | 1945 | Drama|War | | 8582 | Manufacturing Consent: Noam Chomsky and the Media (1992) | 1992 | Documentary|War | | 8589 | Winter War (Talvisota) (1989) | 1989 | Drama|War | | 8630 | Such a Long Journey (1998) | 1998 | Drama|War | | 8640 | King Arthur (2004) | 2004 | Action|Adventure|Drama|War | | 8662 | Joan of Arc (1948) | 1948 | Action|Drama|War | | 8675 | Enemy Below, The (1957) | 1957 | Action|Drama|War | | 8690 | Slaughterhouse-Five (1972) | 1972 | Comedy|Drama|Sci-Fi|War | | 8692 | Wake Island (1942) | 1942 | Drama|War | | 8700 | Destination Tokyo (1943) | 1943 | Adventure|War | | 8724 | Leopard, The (Gattopardo, Il) (1963) | 1963 | Drama|War | | 8775 | Counterfeit Traitor, The (1962) | 1962 | Thriller|War | | 8868 | Head in the Clouds (2004) | 2004 | Drama|Romance|War | | 8977 | Alexander (2004) | 2004 | Action|Adventure|Drama|War | | 9014 | Since You Went Away (1944) | 1944 | Drama|War | | 9018 | Control Room (2004) | 2004 | Documentary|War | | 25810 | Lost Patrol, The (1934) | 1934 | Adventure|Drama|War | | 25846 | Dawn Patrol, The (1938) | 1938 | Drama|War | | 25878 | Across the Pacific (1942) | 1942 | Action|Adventure|Romance|War | | 25879 | All Through the Night (1941) | 1941 | Action|Comedy|Drama|Thriller|War | | 25888 | Action in the North Atlantic (1943) | 1943 | Action|War | | 25908 | Passage to Marseille (1944) | 1944 | Adventure|Drama|War | | 25916 | They Were Expendable (1945) | 1945 | Drama|War | | 26003 | Night and Fog (Nuit et brouillard) (1955) | 1955 | Crime|Documentary|War | | 26007 | Unknown Soldier, The (Tuntematon sotilas) (1955) | 1955 | Drama|War | | 26095 | Carabineers, The (Carabiniers, Les) (1963) | 1963 | Comedy|Drama|War | | 26110 | 36 Hours (1965) | 1965 | Thriller|War | | 26112 | Behold a Pale Horse (1964) | 1964 | Drama|War | | 26122 | Onibaba (1964) | 1964 | Drama|Horror|War | | 26131 | Battle of Algiers, The (La battaglia di Algeri) (1966) | 1966 | Drama|War | | 26148 | Train, The (1964) | 1964 | Action|Thriller|War | | 26150 | Andrei Rublev (Andrey Rublyov) (1969) | 1969 | Drama|War | | 26155 | Khartoum (1966) | 1966 | Action|Adventure|Drama|War | | 26158 | Closely Watched Trains (Ostre sledované vlaky) (1966) | 1966 | Comedy|Drama|War | | 26240 | Beguiled, The (1971) | 1971 | Drama|Thriller|War | | 26246 | Johnny Got His Gun (1971) | 1971 | Drama|War | | 26253 | Nicholas and Alexandra (1971) | 1971 | Drama|War | | 26325 | Hearts and Minds (1974) | 1974 | Documentary|War | | 26359 | 1900 (Novecento) (1976) | 1976 | Drama|War | | 26476 | Merry Christmas Mr. Lawrence (1983) | 1983 | Drama|War | | 26491 | To Be or Not to Be (1983) | 1983 | Comedy|Romance|War | | 26681 | Bullet in the Head (1990) | 1990 | Action|Drama|War | | 26791 | Shining Through (1992) | 1992 | Drama|Romance|Thriller|War | | 27067 | Pentagon Wars, The (1998) | 1998 | Comedy|War | | 27397 | Joint Security Area (Gongdong gyeongbi guyeok JSA) (2000) | 2000 | Crime|Drama|Mystery|Thriller|War | | 27497 | Lost Battalion, The (2001) | 2001 | Action|Drama|War | | 27611 | Battlestar Galactica (2003) | 2003 | Drama|Sci-Fi|War | | 27639 | Twin Sisters (De tweeling) (2002) | 2002 | Drama|Romance|War | | 27692 | And Starring Pancho Villa as Himself (2003) | 2003 | Action|Comedy|Drama|War | | 27704 | Battle Royale 2: Requiem (Batoru rowaiaru II: Chinkonka) (2003) | 2003 | Action|Drama|Thriller|War | | 27721 | Very Long Engagement, A (Un long dimanche de fiançailles) (2004) | 2004 | Drama|Mystery|Romance|War | | 27793 | Starship Troopers 2: Hero of the Federation (2004) | 2004 | Action|Horror|Sci-Fi|War | | 27816 | Saints and Soldiers (2003) | 2003 | Action|Adventure|Drama|War | | 27869 | Tae Guk Gi: The Brotherhood of War (Taegukgi hwinalrimyeo) (2004) | 2004 | Action|Drama|War | | 30749 | Hotel Rwanda (2004) | 2004 | Drama|War | | 31042 | Hell's Angels (1930) | 1930 | Drama|War | | 31116 | Sergeant York (1941) | 1941 | Drama|War | | 31410 | Downfall (Untergang, Der) (2004) | 2004 | Drama|War | | 31528 | Beau Geste (1939) | 1939 | Action|Adventure|Drama|War | | 31584 | Rosenstrasse (2003) | 2003 | Drama|War | | 31617 | El Cid (1961) | 1961 | Action|Adventure|Drama|Romance|War | | 31636 | Bunker, The (2001) | 2001 | Drama|Horror|Mystery|Thriller|War | | 31702 | Turtles Can Fly (Lakposhtha hâm parvaz mikonand) (2004) | 2004 | Drama|War | | 31934 | Four Feathers, The (1939) | 1939 | Adventure|War | | 31973 | Germany Year Zero (Germania anno zero) (Deutschland im Jahre Null) (1948) | 1948 | Drama|War | | 32022 | Gunner Palace (2004) | 2004 | Documentary|War | | 32174 | Green Berets, The (1968) | 1968 | Action|Drama|War | | 32261 | Thirty Seconds Over Tokyo (1944) | 1944 | Drama|War | | 32649 | Special Day, A (Giornata particolare, Una) (1977) | 1977 | Drama|War | | 32721 | Battle of the Bulge (1965) | 1965 | Action|Drama|War | | 32844 | Waterloo Bridge (1940) | 1940 | Drama|Romance|War | | 32853 | Sorrow and the Pity, The (Le chagrin et la pitié) (1969) | 1969 | Documentary|War | | 32892 | Ivan's Childhood (a.k.a. My Name is Ivan) (Ivanovo detstvo) (1962) | 1962 | Drama|War | | 33162 | Kingdom of Heaven (2005) | 2005 | Action|Drama|Romance|War | | 34306 | Journey Into Fear (1943) | 1943 | Drama|Film-Noir|War | | 34536 | The Great Raid (2005) | 2005 | Action|Drama|War | | 36397 | Valiant (2005) | 2005 | Adventure|Animation|Children|Comedy|Fantasy|War | | 36529 | Lord of War (2005) | 2005 | Action|Crime|Drama|Thriller|War | | 36553 | In Old Chicago (1937) | 1937 | Action|Drama|Musical|War | | 37744 | Story of Vernon and Irene Castle, The (1939) | 1939 | Musical|Romance|War | | 38843 | 55 Days at Peking (1963) | 1963 | Drama|War | | 40278 | Jarhead (2005) | 2005 | Action|Drama|War | | 40414 | Joyeux Noël (Merry Christmas) (2005) | 2005 | Drama|War | | 40973 | Wild Geese, The (1978) | 1978 | Action|Adventure|Drama|War | | 41527 | Paradise Now (2005) | 2005 | Crime|Drama|Thriller|War | | 42681 | 49th Parallel (1941) | 1941 | Adventure|Drama|Thriller|War | | 43376 | Sophie Scholl: The Final Days (Sophie Scholl - Die letzten Tage) (2005) | 2005 | Drama|War | | 43482 | Bitter Tea of General Yen, The (1933) | 1933 | Drama|Romance|War | | 43822 | Four Horsemen of the Apocalypse, The (1921) | 1921 | Drama|Romance|War | | 44655 | Trial of Joan of Arc, The (Procès de Jeanne d'Arc) (1962) | 1962 | Drama|War | | 44978 | Dead Birds (2004) | 2004 | Horror|War|Western | | 46559 | Road to Guantanamo, The (2006) | 2006 | Drama|War | | 46855 | Army of Shadows (L'armée des ombres) (1969) | 1969 | Action|Drama|Thriller|War | | 46901 | Purple Plain, The (1954) | 1954 | Drama|War | | 47306 | Canterbury Tale, A (1944) | 1944 | Drama|Mystery|War | | 47894 | Wind That Shakes the Barley, The (2006) | 2006 | Drama|War | | 47935 | Overlord (1975) | 1975 | Drama|War | | 48319 | Flyboys (2006) | 2006 | Action|Adventure|Drama|War | | 48783 | Flags of Our Fathers (2006) | 2006 | Drama|War | | 48825 | 9th Company (2005) | 2005 | Action|Drama|War | | 48957 | Charge of the Light Brigade, The (1936) | 1936 | Action|Adventure|Romance|War | | 49530 | Blood Diamond (2006) | 2006 | Action|Adventure|Crime|Drama|Thriller|War | | 49688 | Dam Busters, The (1955) | 1955 | Action|Drama|War | | 49766 | Man Who Never Was, The (1956) | 1956 | Drama|War | | 50068 | Letters from Iwo Jima (2006) | 2006 | Drama|War | | 50151 | Home of the Brave (2007) | 2007 | Action|Drama|War | | 50828 | Red Angel (Akai tenshi) (1966) | 1966 | Drama|Romance|War | | 51007 | Days of Glory (Indigènes) (2006) | 2006 | Action|Adventure|Drama|War | | 51662 | 300 (2007) | 2007 | Action|Fantasy|War|IMAX | | 52042 | Black Book (Zwartboek) (2006) | 2006 | Drama|Thriller|War | | 52319 | Inglorious Bastards (Quel maledetto treno blindato) (1978) | 1978 | Action|Adventure|Drama|War | | 52321 | Seraphim Falls (2006) | 2006 | Action|Adventure|Drama|War|Western | | 52460 | Pathfinder (2007) | 2007 | Action|Adventure|Drama|Thriller|War | | 53550 | Rescue Dawn (2006) | 2006 | Action|Adventure|Drama|War | | 53967 | High Road to China (1983) | 1983 | Adventure|Drama|Romance|War | | 54075 | Arn: The Knight Templar (Arn - Tempelriddaren) (2007) | 2007 | Action|Adventure|Drama|Romance|War | | 54686 | Last Legion, The (2007) | 2007 | Action|Adventure|Fantasy|War | | 55052 | Atonement (2007) | 2007 | Drama|Romance|War | | 55253 | Lust, Caution (Se, jie) (2007) | 2007 | Drama|Romance|Thriller|War | | 55946 | Lions For Lambs (2007) | 2007 | Drama|Thriller|War | | 56060 | I Served the King of England (Obsluhoval jsem anglického krále) (2006) | 2006 | Comedy|Drama|Romance|War | | 56093 | 12 (2007) | 2007 | Crime|Drama|Thriller|War | | 56511 | Redacted (2007) | 2007 | Action|Crime|Drama|War | | 56788 | Charlie Wilson's War (2007) | 2007 | Comedy|Drama|War | | 57528 | Rambo (Rambo 4) (2008) | 2008 | Action|Drama|Thriller|War | | 57709 | Thunder Rock (1942) | 1942 | Drama|Fantasy|War | | 58303 | Counterfeiters, The (Die Fälscher) (2007) | 2007 | Crime|Drama|War | | 58306 | Mongol (2007) | 2007 | Drama|War | | 58376 | Zeitgeist: The Movie (2007) | 2007 | Documentary|War | | 58876 | Stop-Loss (2008) | 2008 | Drama|War | | 60020 | Warlords, The (Tau ming chong) (2007) | 2007 | Action|Drama|War | | 60046 | Children of Huang Shi, The (2008) | 2008 | Drama|War | | 60503 | Katyn (2007) | 2007 | Drama|War | | 60688 | Conspiracy (2008) | 2008 | Action|Drama|Mystery|Thriller|War | | 60894 | Edge of Love, The (2008) | 2008 | Drama|Romance|War | | 61026 | Red Cliff (Chi bi) (2008) | 2008 | Action|Adventure|Drama|War | | 61132 | Tropic Thunder (2008) | 2008 | Action|Adventure|Comedy|War | | 61136 | Objective, The (2008) | 2008 | Horror|Sci-Fi|Thriller|War | | 61236 | Waltz with Bashir (Vals im Bashir) (2008) | 2008 | Animation|Documentary|Drama|War | | 61434 | Oh! What a Lovely War (1969) | 1969 | Musical|War | | 61451 | Seventh Cross, The (1944) | 1944 | Drama|War | | 61470 | Boys in Company C, The (1978) | 1978 | Drama|War | | 62764 | Black Moon (1975) | 1975 | Fantasy|Mystery|Sci-Fi|War | | 63853 | Australia (2008) | 2008 | Adventure|Drama|War|Western | | 64034 | Boy in the Striped Pajamas, The (Boy in the Striped Pyjamas, The) (2008) | 2008 | Drama|War | | 64499 | Che: Part One (2008) | 2008 | Drama|War | | 64983 | Valkyrie (2008) | 2008 | Drama|Thriller|War | | 65216 | Defiance (2008) | 2008 | Drama|Thriller|War | | 65514 | Ip Man (2008) | 2008 | Action|Drama|War | | 66015 | Passchendaele (2008) | 2008 | Action|Drama|Romance|War | | 66385 | Taking Chance (2009) | 2009 | Drama|War | | 67422 | California Dreamin' (Nesfarsit) (2007) | 2007 | Comedy|Drama|War | | 68157 | Inglourious Basterds (2009) | 2009 | Action|Drama|War | | 68486 | Red Cliff Part II (Chi Bi Xia: Jue Zhan Tian Xia) (2009) | 2009 | Action|Drama|War | | 68872 | Paisan (Paisà) (1946) | 1946 | Drama|War | | 69324 | Flame and Citron (Flammen & Citronen) (2008) | 2008 | Action|Drama|War | | 69354 | Went the Day Well? (1942) | 1942 | Thriller|War | | 69481 | Hurt Locker, The (2008) | 2008 | Action|Drama|Thriller|War | | 69849 | Roots (1977) | 1977 | Drama|War | | 70342 | Séraphine (2008) | 2008 | Drama|War | | 70451 | Max Manus (2008) | 2008 | Action|Drama|War | | 71011 | Five Graves to Cairo (1943) | 1943 | Thriller|War | | 72479 | Messenger, The (2009) | 2009 | Drama|Romance|War | | 72605 | Brothers (2009) | 2009 | Drama|Thriller|War | | 73954 | Air Force (1943) | 1943 | Action|Drama|War | | 74547 | Darling Lili (1970) | 1970 | Drama|War | | 74575 | Secret of Santa Vittoria, The (1969) | 1969 | Comedy|Drama|War | | 74688 | Dear John (2010) | 2010 | Drama|Romance|War | | 74795 | Green Zone (2010) | 2010 | Action|Drama|Thriller|War | | 76244 | Glorious 39 (2009) | 2009 | Drama|Romance|Thriller|War | | 77201 | Valhalla Rising (2009) | 2009 | Action|Drama|War | | 77496 | Night Train to Munich (1941) | 1941 | Film-Noir|Thriller|War | | 77596 | Lebanon (2009) | 2009 | Drama|War | | 77866 | Robin Hood (2010) | 2010 | Action|Adventure|Drama|Romance|War | | 78944 | Culloden (The Battle of Culloden) (1964) | 1964 | Documentary|Drama|War | | 79388 | Play Dirty (1969) | 1969 | Action|Adventure|Drama|War | | 79663 | Triage (2009) | 2009 | Drama|War | | 79796 | Centurion (2010) | 2010 | Action|Adventure|Drama|Thriller|War | | 79830 | Captain Conan (Capitaine Conan) (1996) | 1996 | Drama|War | | 80264 | Pride of the Marines (1945) | 1945 | Drama|War | | 80348 | Arch of Triumph (1948) | 1948 | Drama|Romance|War | | 81158 | Restrepo (2010) | 2010 | Documentary|War | | 82564 | Last of the Mohicans, The (1936) | 1936 | Adventure|Drama|War | | 83059 | White Material (2009) | 2009 | Drama|Mystery|Thriller|War | | 83189 | Merrill's Marauders (1962) | 1962 | Adventure|Drama|War | | 83577 | Spy in Black, The (1939) | 1939 | Thriller|War | | 84730 | Army of Crime (L'armée du crime) (2009) | 2009 | Drama|Thriller|War | | 85010 | Background to Danger (1943) | 1943 | Drama|Thriller|War | | 85131 | Battle: Los Angeles (2011) | 2011 | Action|Sci-Fi|War | | 85763 | Beneath Hill 60 (2010) | 2010 | Drama|War | | 86432 | Outside the Law (Hors-la-loi) (2010) | 2010 | Crime|Drama|War | | 86781 | Incendies (2010) | 2010 | Drama|Mystery|War | | 86931 | This Above All (1942) | 1942 | Drama|Romance|War | | 86973 | John Rabe (2009) | 2009 | Drama|War | | 87232 | X-Men: First Class (2011) | 2011 | Action|Adventure|Sci-Fi|Thriller|War | | 87520 | Transformers: Dark of the Moon (2011) | 2011 | Action|Adventure|Sci-Fi|War|IMAX | | 88140 | Captain America: The First Avenger (2011) | 2011 | Action|Adventure|Sci-Fi|Thriller|War | | 90384 | Behind Enemy Lines II: Axis of Evil (2006) | 2006 | Action|Thriller|War | | 91126 | War Horse (2011) | 2011 | Drama|War | | 91707 | In the Land of Blood and Honey (2011) | 2011 | Drama|Romance|War | | 91727 | Toast of New York, The (1937) | 1937 | Comedy|Drama|War | | 92234 | Red Tails (2012) | 2012 | Action|Adventure|Drama|War | | 92243 | Flowers of War, The (Jin líng shí san chai) (2011) | 2011 | Drama|War | | 92841 | Winter in Wartime (Oorlogswinter) (2008) | 2008 | Drama|War | | 93040 | Civil War, The (1990) | 1990 | Documentary|War | | 93297 | Act of Valor (2012) | 2012 | Action|Thriller|War | | 94998 | 5 Days of War (2011) | 2011 | Action|Drama|War | | 97646 | Four Sons (1940) | 1940 | Drama|War | | 97826 | Patience Stone, The (2012) | 2012 | Drama|War | | 97878 | Remember the Day (1941) | 1941 | Drama|Romance|War | | 98154 | Lincoln (2012) | 2012 | Drama|War | | 98239 | Red Dawn (2012) | 2012 | Action|War | | 98284 | Fire Over England (1937) | 1937 | Adventure|Romance|War | | 100091 | Hitler's Madman (1943) | 1943 | Drama|War | | 100440 | Lore (2012) | 2012 | Drama|Thriller|War | | 101064 | Verboten! (1959) | 1959 | Action|Romance|War | | 101207 | Emperor (2012) | 2012 | Drama|War | | 102688 | Garbo the Spy (Garbo: El espía) (2009) | 2009 | Documentary|War | | 104642 | Sealed Cargo (1951) | 1951 | Thriller|War | | 106441 | Book Thief, The (2013) | 2013 | Children|Drama|War | | 107069 | Lone Survivor (2013) | 2013 | Action|Drama|Thriller|War | | 108928 | Monuments Men, The (2014) | 2014 | Action|Drama|War | | 109673 | 300: Rise of an Empire (2014) | 2014 | Action|Drama|War|IMAX | | 110030 | Bless Me, Ultima (2013) | 2013 | Drama|War | | 113083 | Westfront 1918 (1930) | 1930 | Drama|War | | 114273 | Bethlehem (2013) | 2013 | Drama|Thriller|War | | 114662 | American Sniper (2014) | 2014 | Action|War | | 115210 | Fury (2014) | 2014 | Action|Drama|War | | 115923 | Seal Team Eight: Behind Enemy Lines (2014) | 2014 | Action|Drama|War | | 116797 | The Imitation Game (2014) | 2014 | Drama|Thriller|War | | 117364 | Virunga (2014) | 2014 | Documentary|War | | 117750 | The Real Glory (1939) | 1939 | War | | 117867 | '71 (2014) | 2014 | Action|Drama|Thriller|War | | 118702 | Unbroken (2014) | 2014 | Drama|War | | 126430 | The Pacific (2010) | 2010 | Action|Adventure|Drama|War | | 132381 | The Admiral: Roaring Currents (2014) | 2014 | Action|Drama|War | | 132883 | Testament of Youth (2014) | 2014 | Drama|War | | 135504 | Little Boy (2015) | 2015 | Comedy|Drama|War | +---------+-----------------------------------------------------------------------------+------+-------------------------------------------------+ B503 rows in set (0.005 sec) BB BMariaDB [movie_test]> e [1]+ Stopped mysql movie_test nick@artemis:~$ cd public_html/3420/movies nick@artemis:~/public_html/3420/movies$ ls -l total 4 -rw-r--r-- 1 nick nick 2384 Nov 20 13:52 genres.php nick@artemis:~/public_html/3420/movies$ cp .notyet/genres.php genres2.php nick@artemis:~/public_html/3420/movies$ cp .notyet/pagination.php . nick@artemis:~/public_html/3420/movies$ cd ~nick/public_html/3420/movies/ nick@artemis:~/public_html/3420/movies$ ls -l total 16 -rw-r--r-- 1 nick nick 3282 Nov 20 13:52 genres2.php -rw-r--r-- 1 nick nick 2392 Nov 20 13:54 genres.php -rw-r--r-- 1 nick nick 4826 Nov 20 13:58 pagination.php nick@artemis:~/public_html/3420/movies$ exitt logout There are stopped jobs. nick@artemis:~/public_html/3420/movies$ exit logout Connection to artemis.cs.csub.edu closed. nick@Vaxis:~$ ssh artemis Linux artemis 5.10.0-28-amd64 #1 SMP Debian 5.10.209-2 (2024-01-31) x86_64 The programs included with the Debian GNU/Linux system are free software; the exact distribution terms for each program are described in the individual files in /usr/share/doc/*/copyright. Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent permitted by applicable law. Last login: Wed Nov 20 13:20:45 2024 from 136.168.38.41 nick@artemis:~$ mysql companyf24 Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A BWelcome to the MariaDB monitor. Commands end with ; or \g. BBYour MariaDB connection id is 104144 Server version: 10.3.38-MariaDB-0+deb10u1 Debian 10 BBCopyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. BBType 'help;' or '\h' for help. Type '\c' to clear the current input statement. BMariaDB [companyf24]> describe Employee; +----------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------------+------+-----+---------+-------+ | SSN | varchar(12) | NO | PRI | NULL | | | Dnumber | int(11) | NO | MUL | NULL | | | Fname | varchar(50) | YES | | NULL | | | Minit | char(1) | YES | | NULL | | | Lname | varchar(50) | NO | | NULL | | | DateOfBirth | date | YES | | NULL | | | Address | varchar(255) | YES | | NULL | | | Salary | int(10) unsigned | YES | | NULL | | | SupervisorSSN | varchar(12) | YES | MUL | NULL | | | PasswordPlain | varchar(60) | YES | | NULL | | | PasswordHashed | varchar(60) | YES | | NULL | | +----------------+------------------+------+-----+---------+-------+ B11 rows in set (0.001 sec) BB BMariaDB [companyf24]> [1]+ Stopped mysql companyf24 nick@artemis:~$ php -a Interactive mode enabled pSET> echo "UPDATE Employee ?,uAddress?= ?"ame = ? php " ";p " ; UPDATE Employee SET php > exit nick@artemis:~$ exit logout There are stopped jobs. nick@artemis:~$ exit logout Connection to artemis.cs.csub.edu closed. nick@Vaxis:~$ exit exit