Posted By

sensimevanidus on 06/18/09


Tagged

mysql list countries country turkish


Versions (?)

MySQL Table - list of all country names (in Turkish)


 / Published in: MySQL
 

This will create and then populate a MySQL table with a list of the names for countries in existence. Country names are in Turkish language.

  1. -- phpMyAdmin SQL Dump
  2. -- version 3.1.2deb1
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Host: localhost
  6. -- Generation Time: Jun 18, 2009 at 11:31 PM
  7. -- Server version: 5.0.75
  8. -- PHP Version: 5.2.6-3ubuntu4.1
  9.  
  10. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  11.  
  12. --
  13. -- Table structure for table `countries_list`
  14. --
  15.  
  16. CREATE TABLE IF NOT EXISTS `countries_list` (
  17. `country_id` TINYINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
  18. `country_name` VARCHAR(30) COLLATE utf8_turkish_ci NOT NULL,
  19. PRIMARY KEY (`country_id`)
  20. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci AUTO_INCREMENT=207 ;
  21.  
  22. --
  23. -- Dumping data for table `countries_list`
  24. --
  25.  
  26. INSERT INTO `countries_list` (`country_id`, `country_name`) VALUES
  27. (1, 'Abhazya'),
  28. (2, 'Afganistan'),
  29. (3, 'Almanya'),
  30. (4, 'Amerika BirleÅŸik Devletleri'),
  31. (5, 'Andorra'),
  32. (6, 'Angola'),
  33. (7, 'Antigua ve Barbuda'),
  34. (8, 'Arjantin'),
  35. (9, 'Arnavutluk'),
  36. (10, 'Avustralya'),
  37. (11, 'Avusturya'),
  38. (12, 'Azerbaycan'),
  39. (13, 'Bahamalar'),
  40. (14, 'Bahreyn'),
  41. (15, 'BangladeÅŸ'),
  42. (16, 'Barbados'),
  43. (17, 'Batı Sahra'),
  44. (18, 'Belarus'),
  45. (19, 'Belçika'),
  46. (20, 'Belize'),
  47. (21, 'Benin'),
  48. (22, 'Bhutan'),
  49. (23, 'BirleÅŸik Arap Emirlikleri'),
  50. (24, 'Bolivya'),
  51. (25, 'Bosna Hersek'),
  52. (26, 'Botsvana'),
  53. (27, 'Brezilya'),
  54. (28, 'Brunei'),
  55. (29, 'Bulgaristan'),
  56. (30, 'Burkina Faso'),
  57. (31, 'Burundi'),
  58. (32, 'Cezayir'),
  59. (33, 'Cibuti Cumhuriyeti'),
  60. (34, 'Çad'),
  61. (35, 'Çek Cumhuriyeti'),
  62. (36, 'Çin Halk Cumhuriyeti'),
  63. (37, 'Dağlık Karabağ Cumhuriyeti'),
  64. (38, 'Danimarka'),
  65. (39, 'DoÄŸu Timor'),
  66. (40, 'Dominik Cumhuriyeti'),
  67. (41, 'Dominika'),
  68. (42, 'Ekvador'),
  69. (43, 'Ekvator Ginesi'),
  70. (44, 'El Salvador'),
  71. (45, 'Endonezya'),
  72. (46, 'Eritre'),
  73. (47, 'Ermenistan'),
  74. (48, 'Estonya'),
  75. (49, 'Etiyopya'),
  76. (50, 'Fas'),
  77. (51, 'Fiji'),
  78. (52, 'FildiÅŸi Sahilleri'),
  79. (53, 'Filipinler'),
  80. (54, 'Filistin'),
  81. (55, 'Finlandiya'),
  82. (56, 'Fransa'),
  83. (57, 'Gabon'),
  84. (58, 'Gambiya'),
  85. (59, 'Gana'),
  86. (60, 'Gine Bissau'),
  87. (61, 'Gine'),
  88. (62, 'Grenada'),
  89. (63, 'Guyana'),
  90. (64, 'Guatemala'),
  91. (65, 'Güney Afrika Cumhuriyeti'),
  92. (66, 'Güney Kore'),
  93. (67, 'Güney Osetya'),
  94. (68, 'Gürcistan'),
  95. (69, 'Haiti'),
  96. (70, 'Hırvatistan'),
  97. (71, 'Hindistan'),
  98. (72, 'Hollanda'),
  99. (73, 'Honduras'),
  100. (74, 'Irak'),
  101. (75, 'Ä°ngiltere'),
  102. (76, 'Ä°ran'),
  103. (77, 'Ä°rlanda'),
  104. (78, 'Ä°spanya'),
  105. (79, 'Ä°srail'),
  106. (80, 'İsveç'),
  107. (81, 'İsviçre'),
  108. (82, 'Ä°talya'),
  109. (83, 'Ä°zlanda'),
  110. (84, 'Jamaika'),
  111. (85, 'Japonya'),
  112. (86, 'Kamboçya'),
  113. (87, 'Kamerun'),
  114. (88, 'Kanada'),
  115. (89, 'KaradaÄŸ'),
  116. (90, 'Katar'),
  117. (91, 'Kazakistan'),
  118. (92, 'Kenya'),
  119. (93, 'Kırgızistan'),
  120. (94, 'Kıbrıs Cumhuriyeti'),
  121. (95, 'Kiribati'),
  122. (96, 'Kolombiya'),
  123. (97, 'Komorlar'),
  124. (98, 'Kongo'),
  125. (99, 'Kongo Demokratik Cumhuriyeti'),
  126. (100, 'Kosova'),
  127. (101, 'Kosta Rika'),
  128. (102, 'Kuveyt'),
  129. (103, 'Kuzey Kıbrıs Türk Cumhuriyeti'),
  130. (104, 'Kuzey Kore'),
  131. (105, 'Küba'),
  132. (106, 'Lakota Cumhuriyeti'),
  133. (107, 'Laos'),
  134. (108, 'Lesotho'),
  135. (109, 'Letonya'),
  136. (110, 'Liberya'),
  137. (111, 'Libya'),
  138. (112, 'Liechtenstein'),
  139. (113, 'Litvanya'),
  140. (114, 'Lübnan'),
  141. (115, 'Lüksemburg'),
  142. (116, 'Macaristan'),
  143. (117, 'Madagaskar'),
  144. (118, 'Makedonya Cumhuriyeti'),
  145. (119, 'Malavi'),
  146. (120, 'Maldivler'),
  147. (121, 'Malezya'),
  148. (122, 'Mali'),
  149. (123, 'Malta'),
  150. (124, 'Marshall Adaları'),
  151. (125, 'Meksika'),
  152. (126, 'Mısır'),
  153. (127, 'Mikronezya'),
  154. (128, 'MoÄŸolistan'),
  155. (129, 'Moldova'),
  156. (130, 'Monako'),
  157. (131, 'Moritanya'),
  158. (132, 'Moritus'),
  159. (133, 'Mozambik'),
  160. (134, 'Myanmar'),
  161. (135, 'Namibya'),
  162. (136, 'Nauru'),
  163. (137, 'Nepal'),
  164. (138, 'Nikaragua'),
  165. (139, 'Nijer'),
  166. (140, 'Nijerya'),
  167. (141, 'Norveç'),
  168. (142, 'Orta Afrika Cumhuriyeti'),
  169. (143, 'Özbekistan'),
  170. (144, 'Pakistan'),
  171. (145, 'Palau'),
  172. (146, 'Panama'),
  173. (147, 'Papua Yeni Gine'),
  174. (148, 'Paraguay'),
  175. (149, 'Peru'),
  176. (150, 'Polonya'),
  177. (151, 'Portekiz'),
  178. (152, 'Romanya'),
  179. (153, 'Ruanda'),
  180. (154, 'Rusya Federasyonu'),
  181. (155, 'Saint Kitts ve Nevis'),
  182. (156, 'Saint Lucia'),
  183. (157, 'Saint Vincent ve Grenadinler'),
  184. (158, 'Samoa'),
  185. (159, 'San Marino'),
  186. (160, 'Sao Tome ve Principe'),
  187. (161, 'Sealand'),
  188. (162, 'Senegal'),
  189. (163, 'SeyÅŸeller'),
  190. (164, 'Sırbistan'),
  191. (165, 'Sierra Leone'),
  192. (166, 'Singapur'),
  193. (167, 'Slovakya'),
  194. (168, 'Slovenya'),
  195. (169, 'Solomon Adaları'),
  196. (170, 'Somali'),
  197. (171, 'Somaliland'),
  198. (172, 'Sri Lanka'),
  199. (173, 'Sudan'),
  200. (174, 'Surinam'),
  201. (175, 'Suudi Arabistan'),
  202. (176, 'Suriye'),
  203. (177, 'Svaziland'),
  204. (178, 'Åžili'),
  205. (179, 'Tacikistan'),
  206. (180, 'Tamil Eelam'),
  207. (181, 'Tanzanya'),
  208. (182, 'Tayland'),
  209. (183, 'Tayvan'),
  210. (184, 'Togo'),
  211. (185, 'Tonga'),
  212. (186, 'Transdinyester'),
  213. (187, 'Trinidad ve Tobago'),
  214. (188, 'Tunus'),
  215. (189, 'Tuvalu'),
  216. (190, 'Türkiye'),
  217. (191, 'Türkmenistan'),
  218. (192, 'Uganda'),
  219. (193, 'Ukrayna'),
  220. (194, 'Umman'),
  221. (195, 'Uruguay'),
  222. (196, 'Ürdün'),
  223. (197, 'Vanuatu'),
  224. (198, 'Vatikan'),
  225. (199, 'Venezuela'),
  226. (200, 'Vietnam'),
  227. (201, 'Yemen'),
  228. (202, 'Yeni Zelanda'),
  229. (203, 'YeÅŸil Burun'),
  230. (204, 'Yunanistan'),
  231. (205, 'Zambiya'),
  232. (206, 'Zimbabve');

Report this snippet  

Comments

RSS Icon Subscribe to comments
Posted By: safaksaracoglu on March 16, 2012

Teşekkür ederim script projem için gerekliydi Klavyeniz dert görmesin :)

You need to login to post a comment.