Advertisement
Guest User

SQL číselník zemí (CZ)

a guest
Sep 24th, 2013
238
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 5.98 KB | None | 0 0
  1. INSERT INTO
  2. zeme (kod, cesky_nazev)
  3. VALUES
  4. ("AF","Afghánistán"),
  5. ("AL","Albánie"),
  6. ("AQ","Antarktida"),
  7. ("DZ","Alžírsko"),
  8. ("AS","Americká Samoa"),
  9. ("AD","Andorra"),
  10. ("AO","Angola"),
  11. ("AG","Antigua a Barbuda"),
  12. ("AZ","Ázerbájdžán"),
  13. ("AR","Argentina"),
  14. ("AU","Austrálie"),
  15. ("AT","Rakousko"),
  16. ("BS","Bahamy"),
  17. ("BH","Bahrajn"),
  18. ("BD","Bangladéš"),
  19. ("AM","Arménie"),
  20. ("BB","Barbados"),
  21. ("BE","Belgie"),
  22. ("BM","Bermudy"),
  23. ("BT","Bhútán"),
  24. ("BO","Mnohonárodní stát Bolívie"),
  25. ("BA","Bosna a Hercegovina"),
  26. ("BW","Botswana"),
  27. ("BV","Bouvetův ostrov"),
  28. ("BR","Brazílie"),
  29. ("BZ","Belize"),
  30. ("IO","Britské indickooceánské území"),
  31. ("SB","Šalomounovy ostrovy"),
  32. ("VG","Britské Panenské ostrovy"),
  33. ("XK","Kosovo"),
  34. ("BN","Brunej Darussalam"),
  35. ("BG","Bulharsko"),
  36. ("MM","Myanma"),
  37. ("BI","Burundi"),
  38. ("BY","Bělorusko"),
  39. ("KH","Kambodža"),
  40. ("CM","Kamerun"),
  41. ("CA","Kanada"),
  42. ("CV","Kapverdy"),
  43. ("KY","Kajmanské ostrovy"),
  44. ("CF","Středoafrická republika"),
  45. ("LK","Srí Lanka"),
  46. ("TD","Čad"),
  47. ("CL","Chile"),
  48. ("CN","Čína"),
  49. ("TW","Tchaj-wan (čínská provincie)"),
  50. ("CX","Vánoční ostrov"),
  51. ("CC","Kokosové (Keelingovy) ostrovy"),
  52. ("CO","Kolumbie"),
  53. ("KM","Komory"),
  54. ("YT","Mayotte"),
  55. ("CG","Kongo, republika"),
  56. ("CD","Kongo, demokratická republika"),
  57. ("CK","Cookovy ostrovy"),
  58. ("CR","Kostarika"),
  59. ("HR","Chorvatsko"),
  60. ("CU","Kuba"),
  61. ("CY","Kypr"),
  62. ("CZ","Česká republika"),
  63. ("BJ","Benin"),
  64. ("DK","Dánsko"),
  65. ("DM","Dominika"),
  66. ("DO","Dominikánská republika"),
  67. ("EC","Ekvádor"),
  68. ("SV","Salvador"),
  69. ("GQ","Rovníková Guinea"),
  70. ("ET","Etiopie"),
  71. ("ER","Eritrea"),
  72. ("EE","Estonsko"),
  73. ("FO","Faerské ostrovy"),
  74. ("FK","Falklandské ostrovy (Malvíny)"),
  75. ("GS","Jižní Georgie a Jižní Sandwichovy ostrovy"),
  76. ("FJ","Fidži"),
  77. ("FI","Finsko"),
  78. ("AX","Alandské ostrovy"),
  79. ("FR","Francie"),
  80. ("GF","Francouzská Guyana"),
  81. ("PF","Francouzská Polynésie"),
  82. ("TF","Francouzská jižní území"),
  83. ("DJ","Džibutsko"),
  84. ("GA","Gabon"),
  85. ("GE","Gruzie"),
  86. ("GM","Gambie"),
  87. ("PS","Palestinské území (okupované)"),
  88. ("DE","Německo"),
  89. ("GH","Ghana"),
  90. ("GI","Gibraltar"),
  91. ("KI","Kiribati"),
  92. ("GR","Řecko"),
  93. ("GL","Grónsko"),
  94. ("GD","Grenada"),
  95. ("GP","Guadeloupe"),
  96. ("GU","Guam"),
  97. ("GT","Guatemala"),
  98. ("GN","Guinea"),
  99. ("GY","Guyana"),
  100. ("HT","Haiti"),
  101. ("HM","Heardův ostrov a McDonaldovy ostrovy"),
  102. ("VA","Svatý stolec (Vatikánský městský stát)"),
  103. ("HN","Honduras"),
  104. ("HK","Hongkong"),
  105. ("HU","Maďarsko"),
  106. ("IS","Island"),
  107. ("IN","Indie"),
  108. ("ID","Indonésie"),
  109. ("IR","Írán (islámská republika)"),
  110. ("IQ","Irák"),
  111. ("IE","Irsko"),
  112. ("IL","Izrael"),
  113. ("IT","Itálie"),
  114. ("CI","Pobřeží Slonoviny"),
  115. ("JM","Jamajka"),
  116. ("JP","Japonsko"),
  117. ("KZ","Kazachstán"),
  118. ("JO","Jordánsko"),
  119. ("KE","Keňa"),
  120. ("KP","Korea, lidově demokratická republika"),
  121. ("KR","Korejská republika"),
  122. ("KW","Kuvajt"),
  123. ("KG","Kyrgyzstán"),
  124. ("LA","Laoská lidově demokratická republika"),
  125. ("LB","Libanon"),
  126. ("LS","Lesotho"),
  127. ("LV","Lotyšsko"),
  128. ("LR","Libérie"),
  129. ("LY","Libye"),
  130. ("LI","Lichtenštejnsko"),
  131. ("LT","Litva"),
  132. ("LU","Lucembursko"),
  133. ("MO","Macao"),
  134. ("MG","Madagaskar"),
  135. ("MW","Malawi"),
  136. ("MY","Malajsie"),
  137. ("MV","Maledivy"),
  138. ("ML","Mali"),
  139. ("MT","Malta"),
  140. ("MQ","Martinik"),
  141. ("MR","Mauritánie"),
  142. ("MU","Mauricius"),
  143. ("MX","Mexiko"),
  144. ("MC","Monako"),
  145. ("MN","Mongolsko"),
  146. ("MD","Moldavská republika"),
  147. ("ME","Černá Hora"),
  148. ("MS","Montserrat"),
  149. ("MA","Maroko"),
  150. ("MZ","Mosambik"),
  151. ("OM","Omán"),
  152. ("NA","Namibie"),
  153. ("NR","Nauru"),
  154. ("NP","Nepál"),
  155. ("NL","Nizozemsko"),
  156. ("CW","Curaçao"),
  157. ("AW","Aruba"),
  158. ("SX","Svatý Martin (nizozemská část)"),
  159. ("BQ","Bonaire, Svatý Eustach a Saba"),
  160. ("NC","Nová Kaledonie"),
  161. ("VU","Vanuatu"),
  162. ("NZ","Nový Zéland"),
  163. ("NI","Nikaragua"),
  164. ("NE","Niger"),
  165. ("NG","Nigérie"),
  166. ("NU","Niue"),
  167. ("NF","Ostrov Norfolk"),
  168. ("NO","Norsko"),
  169. ("MP","Ostrovy Severní Mariany"),
  170. ("UM","Menší odlehlé ostrovy USA"),
  171. ("FM","Mikronésie, federativní státy"),
  172. ("MH","Marshallovy ostrovy"),
  173. ("PW","Palau"),
  174. ("PK","Pákistán"),
  175. ("PA","Panama"),
  176. ("PG","Papua Nová Guinea"),
  177. ("PY","Paraguay"),
  178. ("PE","Peru"),
  179. ("PH","Filipíny"),
  180. ("PN","Pitcairn"),
  181. ("PL","Polsko"),
  182. ("PT","Portugalsko"),
  183. ("GW","Guinea-Bissau"),
  184. ("TL","Východní Timor"),
  185. ("PR","Portoriko"),
  186. ("QA","Katar"),
  187. ("RE","Réunion"),
  188. ("RO","Rumunsko"),
  189. ("RU","Ruská federace"),
  190. ("RW","Rwanda"),
  191. ("BL","Svatý Bartoloměj"),
  192. ("SH","Svatá Helena, Ascension a Tristan da Cunha"),
  193. ("KN","Svatý Kryštof a Nevis"),
  194. ("AI","Anguilla"),
  195. ("LC","Svatá Lucie"),
  196. ("MF","Svatý Martin (francouzská část)"),
  197. ("PM","Saint Pierre a Miquelon"),
  198. ("VC","Svatý Vincenc a Grenadiny"),
  199. ("SM","San Marino"),
  200. ("ST","Svatý Tomáš a Princův ostrov"),
  201. ("SA","Saúdská Arábie"),
  202. ("SN","Senegal"),
  203. ("RS","Srbsko"),
  204. ("SC","Seychely"),
  205. ("SL","Sierra Leone"),
  206. ("SG","Singapur"),
  207. ("SK","Slovensko"),
  208. ("VN","Vietnam"),
  209. ("SI","Slovinsko"),
  210. ("SO","Somálsko"),
  211. ("ZA","Jižní Afrika"),
  212. ("ZW","Zimbabwe"),
  213. ("ES","Španělsko"),
  214. ("SS","Jižní Súdán"),
  215. ("SD","Súdán"),
  216. ("EH","Západní Sahara"),
  217. ("SR","Surinam"),
  218. ("SJ","Svalbard a Jan Mayen"),
  219. ("SZ","Svazijsko"),
  220. ("SE","Švédsko"),
  221. ("CH","Švýcarsko"),
  222. ("SY","Syrská arabská republika"),
  223. ("TJ","Tádžikistán"),
  224. ("TH","Thajsko"),
  225. ("TG","Togo"),
  226. ("TK","Tokelau"),
  227. ("TO","Tonga"),
  228. ("TT","Trinidad a Tobago"),
  229. ("AE","Spojené arabské emiráty"),
  230. ("TN","Tunisko"),
  231. ("TR","Turecko"),
  232. ("TM","Turkmenistán"),
  233. ("TC","Ostrovy Turks a Caicos"),
  234. ("TV","Tuvalu"),
  235. ("UG","Uganda"),
  236. ("UA","Ukrajina"),
  237. ("MK","Makedonie, bývalá jugoslávská republika"),
  238. ("EG","Egypt"),
  239. ("GB","Spojené království"),
  240. ("GG","Guernsey"),
  241. ("JE","Jersey"),
  242. ("IM","Ostrov Man"),
  243. ("TZ","Tanzanská sjednocená republika"),
  244. ("US","Spojené státy"),
  245. ("VI","Americké Panenské ostrovy"),
  246. ("BF","Burkina Faso"),
  247. ("UY","Uruguay"),
  248. ("UZ","Uzbekistán"),
  249. ("VE","Bolívarovská republika Venezuela"),
  250. ("WF","Wallis a Futuna"),
  251. ("WS","Samoa"),
  252. ("YE","Jemen"),
  253. ("ZM","Zambie");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement