Posted By

aeboi80 on 07/06/10


Tagged


Versions (?)

Who likes this?

3 people have marked this snippet as a favorite

kubaitis
megadeth_tom
virendrakryadav


MySQL Country Table With Abbreviations and Names


 / Published in: MySQL
 

  1. -- CREATION DATE: JULY 05, 2010
  2. --
  3. -- CREATED BY: CHAD WARREN
  4. --
  5. -- WEBSITE: http://www.iamchad.com
  6.  
  7. SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
  8.  
  9. --
  10. -- Database: `projectt`
  11. --
  12.  
  13. -- --------------------------------------------------------
  14.  
  15. --
  16. -- Table structure for table `country`
  17. --
  18.  
  19. CREATE TABLE IF NOT EXISTS `country` (
  20. `country_id` INT(3) NOT NULL AUTO_INCREMENT,
  21. `country_name` VARCHAR(50) NOT NULL,
  22. `country_abbrev` VARCHAR(3) NOT NULL,
  23. PRIMARY KEY (`country_id`)
  24. ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=236 ;
  25.  
  26. --
  27. -- Dumping data for table `country`
  28. --
  29.  
  30. INSERT INTO `country` (`country_id`, `country_name`, `country_abbrev`) VALUES
  31. (1, 'United States of America', 'US'),
  32. (2, 'Canada', 'CA'),
  33. (3, 'United Kingdom', 'GB'),
  34. (4, 'Afghanistan', 'AF'),
  35. (5, 'Albania', 'AL'),
  36. (6, 'Algeria', 'DZ'),
  37. (7, 'American Somoa', 'AS'),
  38. (8, 'Andorra', 'AD'),
  39. (9, 'Angola', 'AO'),
  40. (10, 'Anguilla', 'AI'),
  41. (11, 'Antarctica', 'AQ'),
  42. (12, 'Antigua and Barbuda', 'AG'),
  43. (13, 'Argentina', 'AR'),
  44. (14, 'Armenia', 'AM'),
  45. (15, 'Aruba', 'AW'),
  46. (16, 'Australia', 'AU'),
  47. (17, 'Austria', 'AT'),
  48. (18, 'Bahamas', 'BS'),
  49. (19, 'Bahrain', 'BH'),
  50. (20, 'Bangladesh', 'BD'),
  51. (21, 'Barbados', 'BB'),
  52. (22, 'Belarus', 'BY'),
  53. (23, 'Belgium', 'BE'),
  54. (24, 'Belize', 'BZ'),
  55. (25, 'Benin', 'BJ'),
  56. (26, 'Bermuda', 'BM'),
  57. (27, 'Bhutan', 'BT'),
  58. (28, 'Bolivia', 'BO'),
  59. (29, 'Bosnia and Herzegovina', 'BA'),
  60. (30, 'Botswana', 'BW'),
  61. (31, 'Bouvet Island', 'BV'),
  62. (32, 'Brazil', 'BR'),
  63. (33, 'British Indian Ocean Territory', 'IO'),
  64. (34, 'Brunei Darussalam', 'BN'),
  65. (35, 'Bulgaria', 'BG'),
  66. (36, 'Burkina Faso', 'BF'),
  67. (37, 'Burundi', 'BI'),
  68. (38, 'Cambodia', 'KH'),
  69. (39, 'Cameroon', 'CM'),
  70. (40, 'Cape Verde', 'CV'),
  71. (41, 'Cayman Islands', 'KY'),
  72. (42, 'Central African Republic', 'CF'),
  73. (43, 'Chad', 'TD'),
  74. (44, 'Chile', 'CL'),
  75. (45, 'China', 'CN'),
  76. (46, 'Christmas Island', 'CX'),
  77. (47, 'Cocos (Keeling) Islands', 'CC'),
  78. (48, 'Colombia', 'CO'),
  79. (49, 'Comoros', 'KM'),
  80. (50, 'Congo', 'CG'),
  81. (51, 'Cook Islands', 'CK'),
  82. (52, 'Costa Rica', 'CR'),
  83. (53, 'Croatia', 'HR'),
  84. (54, 'Cuba', 'CU'),
  85. (55, 'Cyprus', 'CY'),
  86. (56, 'Czech Republic', 'CZ'),
  87. (57, 'Denmark', 'DK'),
  88. (58, 'Djibouti', 'DJ'),
  89. (59, 'Dominica', 'DM'),
  90. (60, 'Dominican Republic', 'DO'),
  91. (61, 'East Timor', 'TP'),
  92. (62, 'Ecuador', 'EC'),
  93. (63, 'Egypt', 'EG'),
  94. (64, 'El Salvador', 'SV'),
  95. (65, 'Equatorial Guinea', 'GQ'),
  96. (66, 'Eritrea', 'ER'),
  97. (67, 'Estonia', 'EE'),
  98. (68, 'Ethiopia', 'ET'),
  99. (69, 'Faroe Islands', 'FO'),
  100. (70, 'Falkland Islands', 'FK'),
  101. (71, 'Fiji', 'FJ'),
  102. (72, 'Finland', 'FI'),
  103. (73, 'France', 'FR'),
  104. (74, 'French Guiana', 'GF'),
  105. (75, 'French Polynesia', 'PF'),
  106. (76, 'French Southern and Antarctic Lands', 'FQ'),
  107. (77, 'Gabon', 'GA'),
  108. (78, 'Gambia', 'GM'),
  109. (79, 'Georgia', 'GE'),
  110. (80, 'Germany', 'DE'),
  111. (81, 'Ghana', 'GH'),
  112. (82, 'Gibraltar', 'GI'),
  113. (83, 'Greece', 'GR'),
  114. (84, 'Greenland', 'GL'),
  115. (85, 'Grenada', 'GD'),
  116. (86, 'Guadaloupe', 'GP'),
  117. (87, 'Guam', 'GU'),
  118. (88, 'Guatemala', 'GT'),
  119. (89, 'Guinea', 'GN'),
  120. (90, 'Guinea-Bissau', 'GW'),
  121. (91, 'Guyana', 'GY'),
  122. (92, 'Haiti', 'HT'),
  123. (93, 'Heard Island and McDonald Islands', 'HM'),
  124. (94, 'Honduras', 'HN'),
  125. (95, 'Hong Kong', 'HK'),
  126. (96, 'Hungary', 'HU'),
  127. (97, 'Iceland', 'IS'),
  128. (98, 'India', 'IN'),
  129. (99, 'Indonesia', 'ID'),
  130. (100, 'Iran', 'IR'),
  131. (101, 'Iraq', 'IQ'),
  132. (102, 'Ireland', 'IE'),
  133. (103, 'Israel', 'IL'),
  134. (104, 'Italy', 'IT'),
  135. (105, 'Ivory Coast', 'CI'),
  136. (106, 'Jamaica', 'JM'),
  137. (107, 'Japan', 'JP'),
  138. (108, 'Jordan', 'JO'),
  139. (109, 'Kazakhstan', 'KZ'),
  140. (110, 'Kenya', 'KE'),
  141. (111, 'North Korea', 'KP'),
  142. (112, 'South Korea', 'KR'),
  143. (113, 'Kuwait', 'KW'),
  144. (114, 'Kyrgyzstan', 'KG'),
  145. (115, 'Laos', 'LA'),
  146. (116, 'Latvia', 'LV'),
  147. (117, 'Lebanon', 'LN'),
  148. (118, 'Lesotho', 'LS'),
  149. (119, 'Liberia', 'LR'),
  150. (120, 'Libya', 'LY'),
  151. (121, 'Liechtenstein', 'LI'),
  152. (122, 'Lithuania', 'LT'),
  153. (123, 'Luxembourg', 'LU'),
  154. (124, 'Macau', 'MO'),
  155. (125, 'Macedonia', 'MK'),
  156. (126, 'Madagascar', 'MG'),
  157. (127, 'Malawi', 'MW'),
  158. (128, 'Malaysia', 'MY'),
  159. (129, 'Maldives', 'MV'),
  160. (130, 'Mali', 'ML'),
  161. (131, 'Malta', 'MT'),
  162. (132, 'Marshall Islands', 'MH'),
  163. (133, 'Martinique', 'MQ'),
  164. (134, 'Mauritania', 'MR'),
  165. (135, 'Mauritius', 'MU'),
  166. (136, 'Mayotte', 'YT'),
  167. (137, 'Mexico', 'MX'),
  168. (138, 'Micronesia', 'FM'),
  169. (139, 'Moldova', 'MD'),
  170. (140, 'Monaco', 'MC'),
  171. (141, 'Mongolia', 'MN'),
  172. (142, 'Montserrat', 'MS'),
  173. (143, 'Morocco', 'MA'),
  174. (144, 'Mozambique', 'MZ'),
  175. (145, 'Myanmar', 'MM'),
  176. (146, 'Namibia', 'NA'),
  177. (147, 'Nauru', 'NR'),
  178. (148, 'Nepal', 'NP'),
  179. (149, 'Netherlands', 'NL'),
  180. (150, 'Netherlands Antilles', 'AN'),
  181. (151, 'New Caledonia', 'NC'),
  182. (152, 'New Hebrides', 'NH'),
  183. (153, 'New Zealand', 'NZ'),
  184. (154, 'Nicaragua', 'NI'),
  185. (155, 'Niger', 'NE'),
  186. (156, 'Nigeria', 'NG'),
  187. (157, 'Niue', 'NU'),
  188. (158, 'Norfolk Island', 'NF'),
  189. (159, 'Norway', 'NO'),
  190. (160, 'Oman', 'OM'),
  191. (161, 'Pakistan', 'PK'),
  192. (162, 'Palau', 'PW'),
  193. (163, 'Panama', 'PA'),
  194. (164, 'Papua New Guinea', 'PG'),
  195. (165, 'Paraguay', 'PY'),
  196. (166, 'Peru', 'PE'),
  197. (167, 'Philippines', 'PH'),
  198. (168, 'Pitcairn', 'PN'),
  199. (169, 'Poland', 'PL'),
  200. (170, 'Portugal', 'PT'),
  201. (171, 'Puerto Rico', 'PR'),
  202. (172, 'Qatar', 'QA'),
  203. (173, 'Reunion', 'RE'),
  204. (174, 'Romania', 'RO'),
  205. (175, 'Russia', 'RU'),
  206. (176, 'Rwanda', 'RW'),
  207. (177, 'St. Christopher-Nevis-Anguilla', 'KN'),
  208. (178, 'St. Helena', 'SH'),
  209. (179, 'St. Lucia', 'LC'),
  210. (180, 'St. Pierre and Miquelon', 'PM'),
  211. (181, 'St. Vincent', 'VC'),
  212. (182, 'Samoa', 'WS'),
  213. (183, 'San Marino', 'SM'),
  214. (184, 'Sao Tome and Principe', 'ST'),
  215. (185, 'Saudi Arabia', 'SA'),
  216. (186, 'Senegal', 'SN'),
  217. (187, 'Seychelles', 'SC'),
  218. (188, 'Sierra Leone', 'SL'),
  219. (189, 'Singapore', 'SG'),
  220. (190, 'Slovakia', 'SK'),
  221. (191, 'Slovenia', 'SI'),
  222. (192, 'Solomon Islands', 'SB'),
  223. (193, 'Somalia', 'SO'),
  224. (194, 'South Africa', 'ZA'),
  225. (195, 'Spain', 'ES'),
  226. (196, 'Sri Lanka', 'LK'),
  227. (197, 'Sudan', 'SD'),
  228. (198, 'Surinam', 'SR'),
  229. (199, 'Svalbard and Jan Mayen', 'SJ'),
  230. (200, 'Swaziland', 'SZ'),
  231. (201, 'Sweden', 'SE'),
  232. (202, 'Switzerland', 'CH'),
  233. (203, 'Syria', 'SY'),
  234. (204, 'Taiwan', 'TW'),
  235. (205, 'Tajikistan', 'TJ'),
  236. (206, 'Tanzania', 'TZ'),
  237. (207, 'Thailand', 'TH'),
  238. (208, 'Togo', 'TG'),
  239. (209, 'Tokelau Islands', 'TK'),
  240. (210, 'Tonga', 'TO'),
  241. (211, 'Trinidad and Tobago', 'TT'),
  242. (212, 'Tunisia', 'TN'),
  243. (213, 'Turkey', 'TR'),
  244. (214, 'Turks and Caicos Islands', 'TC'),
  245. (215, 'Tuvalu', 'TV'),
  246. (216, 'Uganda', 'UG'),
  247. (217, 'Ukraine', 'UA'),
  248. (218, 'United Arab Emirates', 'AE'),
  249. (219, 'United States Miscellaneous Pacific Islands', 'PU'),
  250. (220, 'Uruguay', 'UY'),
  251. (221, 'Uzbekistan', 'UZ'),
  252. (222, 'Vatican City', 'VA'),
  253. (223, 'Venezuela', 'VE'),
  254. (224, 'Vietnam', 'VN'),
  255. (225, 'Virgin Islands (U.S.)', 'VI'),
  256. (226, 'Wallis and Futana', 'WF'),
  257. (227, 'Western Sahara', 'EH'),
  258. (228, 'Yemen', 'YE'),
  259. (229, 'Yugoslavia', 'YU'),
  260. (230, 'Zaire', 'ZR'),
  261. (231, 'Zambia', 'ZM'),
  262. (232, 'Zimbabwe', 'ZW'),
  263. (233, 'Serbia', 'RS'),
  264. (234, 'Montenegro', 'ME'),
  265. (235, 'Republika Srpska', 'RS2');

Report this snippet  

You need to login to post a comment.