2016.9.26小程序---数据库练习2

-- createnobel, 1, 50 2 DROP TABLE nobel; 3 CREATE TABLE nobel( 4 yr INT -- 年份 5 ,SUBJECT VARCHAR(15) -- 奖项 6 ,winner VARCHAR(50) -- 获奖者 7 )DEFAULT CHARSET=utf8; 8 9 GO 10 -- tabnobel, 1, 50 11 INSERT INTO nobel VALUES (1901,‘Chemistry‘,‘Jacobus H. van t Hoff‘); 12 INSERT INTO nobel VALUES (1902,‘Chemistry‘,‘Emil Fischer‘); 13 INSERT INTO nobel VALUES (1903,‘Chemistry‘,‘Svante Arrhenius‘); 14 INSERT INTO nobel VALUES (1904,‘Chemistry‘,‘Sir William Ramsay‘); 15 INSERT INTO nobel VALUES (1905,‘Chemistry‘,‘Adolf von Baeyer‘); 16 INSERT INTO nobel VALUES (1906,‘Chemistry‘,‘Henri Moissan‘); 17 INSERT INTO nobel VALUES (1907,‘Chemistry‘,‘Eduard Buchner‘); 18 INSERT INTO nobel VALUES (1908,‘Chemistry‘,‘Ernest Rutherford‘); 19 INSERT INTO nobel VALUES (1909,‘Chemistry‘,‘Wilhelm Ostwald‘); 20 INSERT INTO nobel VALUES (1910,‘Chemistry‘,‘Otto Wallach‘); 21 INSERT INTO nobel VALUES (1911,‘Chemistry‘,‘Marie Curie‘); 22 INSERT INTO nobel VALUES (1912,‘Chemistry‘,‘Victor Grignard‘); 23 INSERT INTO nobel VALUES (1912,‘Chemistry‘,‘Paul Sabatier‘); 24 INSERT INTO nobel VALUES (1913,‘Chemistry‘,‘Alfred Werner‘); 25 INSERT INTO nobel VALUES (1914,‘Chemistry‘,‘Theodore W. Richards‘); 26 INSERT INTO nobel VALUES (1915,‘Chemistry‘,‘Richard Willst?¤er‘); 27 INSERT INTO nobel VALUES (1918,‘Chemistry‘,‘Fritz Haber‘); 28 INSERT INTO nobel VALUES (1920,‘Chemistry‘,‘Walther Nernst‘); 29 INSERT INTO nobel VALUES (1921,‘Chemistry‘,‘Frederick Soddy‘); 30 INSERT INTO nobel VALUES (1922,‘Chemistry‘,‘Francis W. Aston‘); 31 INSERT INTO nobel VALUES (1923,‘Chemistry‘,‘Fritz Pregl‘); 32 INSERT INTO nobel VALUES (1925,‘Chemistry‘,‘Richard Zsigmondy‘); 33 INSERT INTO nobel VALUES (1926,‘Chemistry‘,‘The Svedberg‘); 34 INSERT INTO nobel VALUES (1927,‘Chemistry‘,‘Heinrich Wieland‘); 35 INSERT INTO nobel VALUES (1928,‘Chemistry‘,‘Adolf Windaus‘); 36 INSERT INTO nobel VALUES (1929,‘Chemistry‘,‘Arthur Harden‘); 37 INSERT INTO nobel VALUES (1929,‘Chemistry‘,‘Hans von Euler-Chelpin‘); 38 INSERT INTO nobel VALUES (1930,‘Chemistry‘,‘Hans Fischer‘); 39 INSERT INTO nobel VALUES (1931,‘Chemistry‘,‘Friedrich Bergius‘); 40 INSERT INTO nobel VALUES (1931,‘Chemistry‘,‘Carl Bosch‘); 41 INSERT INTO nobel VALUES (1932,‘Chemistry‘,‘Irving Langmuir‘); 42 INSERT INTO nobel VALUES (1934,‘Chemistry‘,‘Harold C. Urey‘); 43 INSERT INTO nobel VALUES (1935,‘Chemistry‘,‘Fraric Joliot‘); 44 INSERT INTO nobel VALUES (1935,‘Chemistry‘,‘Ire Joliot-Curie‘); 45 INSERT INTO nobel VALUES (1936,‘Chemistry‘,‘Peter Debye‘); 46 INSERT INTO nobel VALUES (1937,‘Chemistry‘,‘Norman Haworth‘); 47 INSERT INTO nobel VALUES (1937,‘Chemistry‘,‘Paul Karrer‘); 48 INSERT INTO nobel VALUES (1938,‘Chemistry‘,‘Richard Kuhn‘); 49 INSERT INTO nobel VALUES (1939,‘Chemistry‘,‘Adolf Butenandt‘); 50 INSERT INTO nobel VALUES (1939,‘Chemistry‘,‘Leopold Ruzicka‘); 51 INSERT INTO nobel VALUES (1943,‘Chemistry‘,‘George de Hevesy‘); 52 INSERT INTO nobel VALUES (1944,‘Chemistry‘,‘Otto Hahn‘); 53 INSERT INTO nobel VALUES (1945,‘Chemistry‘,‘Artturi Virtanen‘); 54 INSERT INTO nobel VALUES (1946,‘Chemistry‘,‘John H. Northrop‘); 55 INSERT INTO nobel VALUES (1946,‘Chemistry‘,‘Wendell M. Stanley‘); 56 INSERT INTO nobel VALUES (1946,‘Chemistry‘,‘James B.mner‘); 57 INSERT INTO nobel VALUES (1947,‘Chemistry‘,‘Sir Robert Robinson‘); 58 INSERT INTO nobel VALUES (1948,‘Chemistry‘,‘Arne Tiselius‘); 59 INSERT INTO nobel VALUES (1949,‘Chemistry‘,‘William F. Giauque‘); 60 INSERT INTO nobel VALUES (1950,‘Chemistry‘,‘Kurt Alder‘); 61 -- tabnobel, 51, 50 62 INSERT INTO nobel VALUES (1950,‘Chemistry‘,‘Otto Diels‘); 63 INSERT INTO nobel VALUES (1951,‘Chemistry‘,‘Edwin M. McMillan‘); 64 INSERT INTO nobel VALUES (1951,‘Chemistry‘,‘Glenn T. Seaborg‘); 65 INSERT INTO nobel VALUES (1952,‘Chemistry‘,‘Archer J.P. Martin‘); 66 INSERT INTO nobel VALUES (1952,‘Chemistry‘,‘Richard L.M. Synge‘); 67 INSERT INTO nobel VALUES (1953,‘Chemistry‘,‘Hermann Staudinger‘); 68 INSERT INTO nobel VALUES (1954,‘Chemistry‘,‘Linus Pauling‘); 69 INSERT INTO nobel VALUES (1955,‘Chemistry‘,‘Vincent du Vigneaud‘); 70 INSERT INTO nobel VALUES (1956,‘Chemistry‘,‘Sir Cyril Hinshelwood‘); 71 INSERT INTO nobel VALUES (1956,‘Chemistry‘,‘Nikolay Semenov‘); 72 INSERT INTO nobel VALUES (1957,‘Chemistry‘,‘Lord Todd‘); 73 INSERT INTO nobel VALUES (1958,‘Chemistry‘,‘Frederick Sanger‘); 74 INSERT INTO nobel VALUES (1959,‘Chemistry‘,‘Jaroslav Heyrovsky‘); 75 INSERT INTO nobel VALUES (1960,‘Chemistry‘,‘Willard F. Libby‘); 76 INSERT INTO nobel VALUES (1961,‘Chemistry‘,‘Melvin Calvin‘); 77 INSERT INTO nobel VALUES (1962,‘Chemistry‘,‘John C. Kendrew‘); 78 INSERT INTO nobel VALUES (1962,‘Chemistry‘,‘Max F. Perutz‘); 79 INSERT INTO nobel VALUES (1963,‘Chemistry‘,‘Giulio Natta‘); 80 INSERT INTO nobel VALUES (1963,‘Chemistry‘,‘Karl Ziegler‘); 81 INSERT INTO nobel VALUES (1964,‘Chemistry‘,‘Dorothy Crowfoot Hodgkin‘); 82 INSERT INTO nobel VALUES (1965,‘Chemistry‘,‘Robert B. Woodward‘); 83 INSERT INTO nobel VALUES (1966,‘Chemistry‘,‘Robert S. Mulliken‘); 84 INSERT INTO nobel VALUES (1967,‘Chemistry‘,‘Manfred Eigen‘); 85 INSERT INTO nobel VALUES (1967,‘Chemistry‘,‘Ronald G.W. Norrish‘); 86 INSERT INTO nobel VALUES (1967,‘Chemistry‘,‘George Porter‘); 87 INSERT INTO nobel VALUES (1968,‘Chemistry‘,‘Lars Onsager‘); 88 INSERT INTO nobel VALUES (1969,‘Chemistry‘,‘Derek Barton‘); 89 INSERT INTO nobel VALUES (1969,‘Chemistry‘,‘Odd Hassel‘); 90 INSERT INTO nobel VALUES (1970,‘Chemistry‘,‘Luis Leloir‘); 91 INSERT INTO nobel VALUES (1971,‘Chemistry‘,‘Gerhard Herzberg‘); 92 INSERT INTO nobel VALUES (1972,‘Chemistry‘,‘Christian Anfinsen‘); 93 INSERT INTO nobel VALUES (1972,‘Chemistry‘,‘Stanford Moore‘); 94 INSERT INTO nobel VALUES (1972,‘Chemistry‘,‘William H. Stein‘); 95 INSERT INTO nobel VALUES (1973,‘Chemistry‘,‘Ernst Otto Fischer‘); 96 INSERT INTO nobel VALUES (1973,‘Chemistry‘,‘Geoffrey Wilkinson‘); 97 INSERT INTO nobel VALUES (1974,‘Chemistry‘,‘Paul J. Flory‘); 98 INSERT INTO nobel VALUES (1975,‘Chemistry‘,‘John Cornforth‘); 99 INSERT INTO nobel VALUES (1975,‘Chemistry‘,‘Vladimir Prelog‘); 100 INSERT INTO nobel VALUES (1976,‘Chemistry‘,‘William Lipscomb‘); 101 INSERT INTO nobel VALUES (1977,‘Chemistry‘,‘Ilya Prigogine‘); 102 INSERT INTO nobel VALUES (1978,‘Chemistry‘,‘Peter Mitchell‘); 103 INSERT INTO nobel VALUES (1979,‘Chemistry‘,‘Herbert C. Brown‘); 104 INSERT INTO nobel VALUES (1979,‘Chemistry‘,‘Georg Wittig‘); 105 INSERT INTO nobel VALUES (1980,‘Chemistry‘,‘Paul Berg‘); 106 INSERT INTO nobel VALUES (1980,‘Chemistry‘,‘Walter Gilbert‘); 107 INSERT INTO nobel VALUES (1980,‘Chemistry‘,‘Frederick Sanger‘); 108 INSERT INTO nobel VALUES (1981,‘Chemistry‘,‘Kenichi Fukui‘); 109 INSERT INTO nobel VALUES (1981,‘Chemistry‘,‘Roald Hoffmann‘); 110 INSERT INTO nobel VALUES (1982,‘Chemistry‘,‘Aaron Klug‘); 111 INSERT INTO nobel VALUES (1983,‘Chemistry‘,‘Henry Taube‘); 112 -- tabnobel, 101, 50 113 INSERT INTO nobel VALUES (1984,‘Chemistry‘,‘Bruce Merrifield‘); 114 INSERT INTO nobel VALUES (1985,‘Chemistry‘,‘Herbert A. Hauptman‘); 115 INSERT INTO nobel VALUES (1985,‘Chemistry‘,‘Jerome Karle‘); 116 INSERT INTO nobel VALUES (1986,‘Chemistry‘,‘Dudley R. Herschbach‘); 117 INSERT INTO nobel VALUES (1986,‘Chemistry‘,‘Yuan T. Lee‘); 118 INSERT INTO nobel VALUES (1986,‘Chemistry‘,‘John C. Polanyi‘); 119 INSERT INTO nobel VALUES (1987,‘Chemistry‘,‘Donald J. Cram‘); 120 INSERT INTO nobel VALUES (1987,‘Chemistry‘,‘Jean-Marie Lehn‘); 121 INSERT INTO nobel VALUES (1987,‘Chemistry‘,‘Charles J. Pedersen‘); 122 INSERT INTO nobel VALUES (1988,‘Chemistry‘,‘Johann Deisenhofer‘); 123 INSERT INTO nobel VALUES (1988,‘Chemistry‘,‘Robert Huber‘); 124 INSERT INTO nobel VALUES (1988,‘Chemistry‘,‘Hartmut Michel‘); 125 INSERT INTO nobel VALUES (1989,‘Chemistry‘,‘Sidney Altman‘); 126 INSERT INTO nobel VALUES (1989,‘Chemistry‘,‘Thomas R. Cech‘); 127 INSERT INTO nobel VALUES (1990,‘Chemistry‘,‘Elias James Corey‘); 128 INSERT INTO nobel VALUES (1991,‘Chemistry‘,‘Richard R. Ernst‘); 129 INSERT INTO nobel VALUES (1992,‘Chemistry‘,‘Rudolph A. Marcus‘); 130 INSERT INTO nobel VALUES (1993,‘Chemistry‘,‘Kary B. Mullis‘); 131 INSERT INTO nobel VALUES (1993,