[MYSQL] 국가 명칭 테이블

CREATE TABLE IF NOT EXISTS country (
  iso CHAR(2) NOT NULL PRIMARY KEY,
  name VARCHAR(80) NOT NULL,
  printable_name VARCHAR(80) NOT NULL,
  iso3 CHAR(3),
  numcode SMALLINT
);

INSERT INTO country VALUES ('AF','아프가니스탄','Afghanistan','AFG','004');
INSERT INTO country VALUES ('AL','알바니아','Albania','ALB','008');
INSERT INTO country VALUES ('DZ','알제리','Algeria','DZA','012');
INSERT INTO country VALUES ('AS','아메리칸 사모아','American Samoa','ASM','016');
INSERT INTO country VALUES ('AD','안도라','Andorra','AND','020');
INSERT INTO country VALUES ('AO','앙골라','Angola','AGO','024');
INSERT INTO country VALUES ('AI','앵귈라','Anguilla','AIA','660');
INSERT INTO country VALUES ('AQ','남극','Antarctica',NULL,NULL);
INSERT INTO country VALUES ('AG','앤티가바부다','Antigua and Barbuda','ATG','028');
INSERT INTO country VALUES ('AR','아르헨티나','Argentina','ARG','032');
INSERT INTO country VALUES ('AM','아르메니아','Armenia','ARM','051');
INSERT INTO country VALUES ('AW','아루바섬','Aruba','ABW','533');
INSERT INTO country VALUES ('AU','오스트레일리아','Australia','AUS','036');
INSERT INTO country VALUES ('AT','오스트리아','Austria','AUT','040');
INSERT INTO country VALUES ('AZ','아제르바이잔','Azerbaijan','AZE','031');
INSERT INTO country VALUES ('BS','바하마','Bahamas','BHS','044');
INSERT INTO country VALUES ('BH','바레인','Bahrain','BHR','048');
INSERT INTO country VALUES ('BD','방글라데시','Bangladesh','BGD','050');
INSERT INTO country VALUES ('BB','바베이도스','Barbados','BRB','052');
INSERT INTO country VALUES ('BY','벨로루시','Belarus','BLR','112');
INSERT INTO country VALUES ('BE','벨기에','Belgium','BEL','056');
INSERT INTO country VALUES ('BZ','벨리즈','Belize','BLZ','084');
INSERT INTO country VALUES ('BJ','베냉','Benin','BEN','204');
INSERT INTO country VALUES ('BM','버뮤다제도','Bermuda','BMU','060');
INSERT INTO country VALUES ('BT','부탄','Bhutan','BTN','064');
INSERT INTO country VALUES ('BO','볼리비아','Bolivia','BOL','068');
INSERT INTO country VALUES ('BA','보스니아헤르체고비나','Bosnia and Herzegovina','BIH','070');
INSERT INTO country VALUES ('BW','보츠와나','Botswana','BWA','072');
INSERT INTO country VALUES ('BV','부베 섬','Bouvet Island',NULL,NULL);
INSERT INTO country VALUES ('BR','브라질','Brazil','BRA','076');
INSERT INTO country VALUES ('IO','영국령 인도양 식민지','British Indian Ocean Territory',NULL,NULL);
INSERT INTO country VALUES ('BN','브루나이','Brunei Darussalam','BRN','096');
INSERT INTO country VALUES ('BG','불가리아','Bulgaria','BGR','100');
INSERT INTO country VALUES ('BF','부르키나파소','Burkina Faso','BFA','854');
INSERT INTO country VALUES ('BI','브룬디','Burundi','BDI','108');
INSERT INTO country VALUES ('KH','캄보디아','Cambodia','KHM','116');
INSERT INTO country VALUES ('CM','카메룬','Cameroon','CMR','120');
INSERT INTO country VALUES ('CA','캐나다','Canada','CAN','124');
INSERT INTO country VALUES ('CV','카보베르데','Cape Verde','CPV','132');
INSERT INTO country VALUES ('KY','케이맨 제도','Cayman Islands','CYM','136');
INSERT INTO country VALUES ('CF','중앙 아프리카 공화국','Central African Republic','CAF','140');
INSERT INTO country VALUES ('TD','차드','Chad','TCD','148');
INSERT INTO country VALUES ('CL','칠레','Chile','CHL','152');
INSERT INTO country VALUES ('CN','중국','China','CHN','156');
INSERT INTO country VALUES ('CX','크리스마스섬(호주령)','Christmas Island',NULL,NULL);
INSERT INTO country VALUES ('CC','코코스제도(호주령)','Cocos (Keeling) Islands',NULL,NULL);
INSERT INTO country VALUES ('CO','콜롬비아','Colombia','COL','170');
INSERT INTO country VALUES ('KM','코모로','Comoros','COM','174');
INSERT INTO country VALUES ('CG','콩고','Congo','COG','178');
INSERT INTO country VALUES ('CD','콩고민주공화국','Congo, the Democratic Republic of the','COD','180');
INSERT INTO country VALUES ('CK','쿡제도','Cook Islands','COK','184');
INSERT INTO country VALUES ('CR','코스타리카','Costa Rica','CRI','188');
INSERT INTO country VALUES ('CI','코트디부아르','Cote D\'Ivoire','CIV','384');
INSERT INTO country VALUES ('HR','크로아티아','Croatia','HRV','191');
INSERT INTO country VALUES ('CU','쿠바','Cuba','CUB','192');
INSERT INTO country VALUES ('CY','키프로스','Cyprus','CYP','196');
INSERT INTO country VALUES ('CZ','체코','Czech Republic','CZE','203');
INSERT INTO country VALUES ('DK','덴마크','Denmark','DNK','208');
INSERT INTO country VALUES ('DJ','지부티','Djibouti','DJI','262');
INSERT INTO country VALUES ('DM','도미니카 연방','Dominica','DMA','212');
INSERT INTO country VALUES ('DO','도미니카 공화국','Dominican Republic','DOM','214');
INSERT INTO country VALUES ('EC','에콰도르','Ecuador','ECU','218');
INSERT INTO country VALUES ('EG','이집트','Egypt','EGY','818');
INSERT INTO country VALUES ('SV','엘살바도르','El Salvador','SLV','222');
INSERT INTO country VALUES ('GQ','적도기니','Equatorial Guinea','GNQ','226');
INSERT INTO country VALUES ('ER','에리트레아','Eritrea','ERI','232');
INSERT INTO country VALUES ('EE','에스토니아','Estonia','EST','233');
INSERT INTO country VALUES ('ET','에티오피아','Ethiopia','ETH','231');
INSERT INTO country VALUES ('FK','포클랜드제도(영국령)','Falkland Islands (Malvinas)','FLK','238');
INSERT INTO country VALUES ('FO','파로섬(덴마크령)','Faroe Islands','FRO','234');
INSERT INTO country VALUES ('FJ','피지','Fiji','FJI','242');
INSERT INTO country VALUES ('FI','핀란드','Finland','FIN','246');
INSERT INTO country VALUES ('FR','프랑스','France','FRA','250');
INSERT INTO country VALUES ('GF','기아나(프랑스령) ','French Guiana','GUF','254');
INSERT INTO country VALUES ('PF','폴리네시아(프랑스령 )','French Polynesia','PYF','258');
INSERT INTO country VALUES ('TF','프랑스령 남쪽 식민지','French Southern Territories',NULL,NULL);
INSERT INTO country VALUES ('GA','가봉','Gabon','GAB','266');
INSERT INTO country VALUES ('GM','감비아','Gambia','GMB','270');
INSERT INTO country VALUES ('GE','그루지야','Georgia','GEO','268');
INSERT INTO country VALUES ('DE','독일','Germany','DEU','276');
INSERT INTO country VALUES ('GH','가나','Ghana','GHA','288');
INSERT INTO country VALUES ('GI','지브랄터(영국령)','Gibraltar','GIB','292');
INSERT INTO country VALUES ('GR','그리스','Greece','GRC','300');
INSERT INTO country VALUES ('GL','그린랜드','Greenland','GRL','304');
INSERT INTO country VALUES ('GD','그레나다','Grenada','GRD','308');
INSERT INTO country VALUES ('GP','과달루페','Guadeloupe','GLP','312');
INSERT INTO country VALUES ('GU','괌','Guam','GUM','316');
INSERT INTO country VALUES ('GT','과테말라','Guatemala','GTM','320');
INSERT INTO country VALUES ('GN','기니','Guinea','GIN','324');
INSERT INTO country VALUES ('GW','기니비사우','Guinea-Bissau','GNB','624');
INSERT INTO country VALUES ('GY','가이아나','Guyana','GUY','328');
INSERT INTO country VALUES ('HT','아이티','Haiti','HTI','332');
INSERT INTO country VALUES ('HM','헤알드 섬 및 맥도날드 제도','Heard Island and Mcdonald Islands',NULL,NULL);
INSERT INTO country VALUES ('VA','바티칸 시국','Holy See (Vatican City State)','VAT','336');
INSERT INTO country VALUES ('HN','온두라스','Honduras','HND','340');
INSERT INTO country VALUES ('HK','홍콩','Hong Kong','HKG','344');
INSERT INTO country VALUES ('HU','헝가리','Hungary','HUN','348');
INSERT INTO country VALUES ('IS','아이슬란드','Iceland','ISL','352');
INSERT INTO country VALUES ('IN','인도','India','IND','356');
INSERT INTO country VALUES ('ID','인도네시아','Indonesia','IDN','360');
INSERT INTO country VALUES ('IR','이란','Iran, Islamic Republic of','IRN','364');
INSERT INTO country VALUES ('IQ','이라크','Iraq','IRQ','368');
INSERT INTO country VALUES ('IE','아일랜드','Ireland','IRL','372');
INSERT INTO country VALUES ('IL','이스라엘','Israel','ISR','376');
INSERT INTO country VALUES ('IT','이탈리아','Italy','ITA','380');
INSERT INTO country VALUES ('JM','자메이카','Jamaica','JAM','388');
INSERT INTO country VALUES ('JP','일본','Japan','JPN','392');
INSERT INTO country VALUES ('JO','요르단','Jordan','JOR','400');
INSERT INTO country VALUES ('KZ','카자흐스탄','Kazakhstan','KAZ','398');
INSERT INTO country VALUES ('KE','케냐','Kenya','KEN','404');
INSERT INTO country VALUES ('KI','키리바시','Kiribati','KIR','296');
INSERT INTO country VALUES ('KP','북한','Korea, Democratic People\'s Republic of','PRK','408');
INSERT INTO country VALUES ('KR','대한민국','Korea, Republic of','KOR','410');
INSERT INTO country VALUES ('KW','쿠웨이트','Kuwait','KWT','414');
INSERT INTO country VALUES ('KG','키르기스스탄','Kyrgyzstan','KGZ','417');
INSERT INTO country VALUES ('LA','라오스','Lao People\'s Democratic Republic','LAO','418');
INSERT INTO country VALUES ('LV','라트비아','Latvia','LVA','428');
INSERT INTO country VALUES ('LB','레바논','Lebanon','LBN','422');
INSERT INTO country VALUES ('LS','레소토','Lesotho','LSO','426');
INSERT INTO country VALUES ('LR','라이베리아','Liberia','LBR','430');
INSERT INTO country VALUES ('LY','리바아','Libyan Arab Jamahiriya','LBY','434');
INSERT INTO country VALUES ('LI','리히텐슈타인','Liechtenstein','LIE','438');
INSERT INTO country VALUES ('LT','리투아니아','Lithuania','LTU','440');
INSERT INTO country VALUES ('LU','룩셈부르크','Luxembourg','LUX','442');
INSERT INTO country VALUES ('MO','마카오','Macao','MAC','446');
INSERT INTO country VALUES ('MK','마케도니아, THE FORMER YUGOSLAV REPUBLIC OF','Macedonia, the Former Yugoslav Republic of','MKD','807');
INSERT INTO country VALUES ('MG','마다가스카르','Madagascar','MDG','450');
INSERT INTO country VALUES ('MW','말라위','Malawi','MWI','454');
INSERT INTO country VALUES ('MY','말레이시아','Malaysia','MYS','458');
INSERT INTO country VALUES ('MV','몰디브','Maldives','MDV','462');
INSERT INTO country VALUES ('ML','말리','Mali','MLI','466');
INSERT INTO country VALUES ('MT','몰타','Malta','MLT','470');
INSERT INTO country VALUES ('MH','마셜','Marshall Islands','MHL','584');
INSERT INTO country VALUES ('MQ','마르티니크 (프랑스령)','Martinique','MTQ','474');
INSERT INTO country VALUES ('MR','모리타니','Mauritania','MRT','478');
INSERT INTO country VALUES ('MU','모리셔스','Mauritius','MUS','480');
INSERT INTO country VALUES ('YT','마요트','Mayotte',NULL,NULL);
INSERT INTO country VALUES ('MX','멕시코','Mexico','MEX','484');
INSERT INTO country VALUES ('FM','미크로네시아, FEDERATED STATES OF','Micronesia, Federated States of','FSM','583');
INSERT INTO country VALUES ('MD','몰도바','Moldova, Republic of','MDA','498');
INSERT INTO country VALUES ('MC','모나코','Monaco','MCO','492');
INSERT INTO country VALUES ('MN','몽골','Mongolia','MNG','496');
INSERT INTO country VALUES ('MS','몬트세라트섬','Montserrat','MSR','500');
INSERT INTO country VALUES ('MA','모로코','Morocco','MAR','504');
INSERT INTO country VALUES ('MZ','모잠비크','Mozambique','MOZ','508');
INSERT INTO country VALUES ('MM','미얀마','Myanmar','MMR','104');
INSERT INTO country VALUES ('NA','나미비아','Namibia','NAM','516');
INSERT INTO country VALUES ('NR','나우루공화국','Nauru','NRU','520');
INSERT INTO country VALUES ('NP','네팔','Nepal','NPL','524');
INSERT INTO country VALUES ('NL','네델란드','Netherlands','NLD','528');
INSERT INTO country VALUES ('AN','앤틸리스제도(네덜란드령)','Netherlands Antilles','ANT','530');
INSERT INTO country VALUES ('NC','뉴칼레도니아(프)','New Caledonia','NCL','540');
INSERT INTO country VALUES ('NZ','뉴질랜드','New Zealand','NZL','554');
INSERT INTO country VALUES ('NI','니카라과','Nicaragua','NIC','558');
INSERT INTO country VALUES ('NE','니제르','Niger','NER','562');
INSERT INTO country VALUES ('NG','나이지리아','Nigeria','NGA','566');
INSERT INTO country VALUES ('NU','니우에','Niue','NIU','570');
INSERT INTO country VALUES ('NF','노퍽섬 (오스트레일리아령)','Norfolk Island','NFK','574');
INSERT INTO country VALUES ('MP','북마리아나제도','Northern Mariana Islands','MNP','580');
INSERT INTO country VALUES ('NO','노르웨이','Norway','NOR','578');
INSERT INTO country VALUES ('OM','오만','Oman','OMN','512');
INSERT INTO country VALUES ('PK','파키스탄','Pakistan','PAK','586');
INSERT INTO country VALUES ('PW','팔라우','Palau','PLW','585');
INSERT INTO country VALUES ('PS','팔레스타인','Palestinian Territory, Occupied',NULL,NULL);
INSERT INTO country VALUES ('PA','파나마','Panama','PAN','591');
INSERT INTO country VALUES ('PG','파푸아뉴기니','Papua New Guinea','PNG','598');
INSERT INTO country VALUES ('PY','파라과이','Paraguay','PRY','600');
INSERT INTO country VALUES ('PE','페루','Peru','PER','604');
INSERT INTO country VALUES ('PH','필리핀','Philippines','PHL','608');
INSERT INTO country VALUES ('PN','핏케언섬(영국령)','Pitcairn','PCN','612');
INSERT INTO country VALUES ('PL','폴란드','Poland','POL','616');
INSERT INTO country VALUES ('PT','포르투칼','Portugal','PRT','620');
INSERT INTO country VALUES ('PR','푸에르토리코','Puerto Rico','PRI','630');
INSERT INTO country VALUES ('QA','카타르','Qatar','QAT','634');
INSERT INTO country VALUES ('RE','레위니옹','Reunion','REU','638');
INSERT INTO country VALUES ('RO','루마니아','Romania','ROM','642');
INSERT INTO country VALUES ('RU','러시아','Russian Federation','RUS','643');
INSERT INTO country VALUES ('RW','르완다','Rwanda','RWA','646');
INSERT INTO country VALUES ('SH','세인트 헬레나 (영국령)','Saint Helena','SHN','654');
INSERT INTO country VALUES ('KN','세인트키츠네비스','Saint Kitts and Nevis','KNA','659');
INSERT INTO country VALUES ('LC','세인트루시아','Saint Lucia','LCA','662');
INSERT INTO country VALUES ('PM','세인트피에르미켈랑(프랑스령)','Saint Pierre and Miquelon','SPM','666');
INSERT INTO country VALUES ('VC','세인트빈센트그레나딘','Saint Vincent and the Grenadines','VCT','670');
INSERT INTO country VALUES ('WS','사모아','Samoa','WSM','882');
INSERT INTO country VALUES ('SM','산마리노','San Marino','SMR','674');
INSERT INTO country VALUES ('ST','상투메프린시페','Sao Tome and Principe','STP','678');
INSERT INTO country VALUES ('SA','사우디아라비아','Saudi Arabia','SAU','682');
INSERT INTO country VALUES ('SN','세네갈','Senegal','SEN','686');
INSERT INTO country VALUES ('CS','세르비아몬테네그로','Serbia and Montenegro',NULL,NULL);
INSERT INTO country VALUES ('SC','세이셸','Seychelles','SYC','690');
INSERT INTO country VALUES ('SL','시에라리온','Sierra Leone','SLE','694');
INSERT INTO country VALUES ('SG','싱가포르','Singapore','SGP','702');
INSERT INTO country VALUES ('SK','슬로바키아','Slovakia','SVK','703');
INSERT INTO country VALUES ('SI','슬로베니아','Slovenia','SVN','705');
INSERT INTO country VALUES ('SB','솔로몬','Solomon Islands','SLB','090');
INSERT INTO country VALUES ('SO','소말리아','Somalia','SOM','706');
INSERT INTO country VALUES ('ZA','남아프리카공화국','South Africa','ZAF','710');
INSERT INTO country VALUES ('GS','사우스조지아 사우스샌드위치 제도 SOUTH SANDWICH ISLANDS','South Georgia and the South Sandwich Islands',NULL,NULL);
INSERT INTO country VALUES ('ES','스페인','Spain','ESP','724');
INSERT INTO country VALUES ('LK','스리랑카','Sri Lanka','LKA','144');
INSERT INTO country VALUES ('SD','수단','Sudan','SDN','736');
INSERT INTO country VALUES ('SR','수리남','Suriname','SUR','740');
INSERT INTO country VALUES ('SJ','스발비드 군도','Svalbard and Jan Mayen','SJM','744');
INSERT INTO country VALUES ('SZ','스와질란드','Swaziland','SWZ','748');
INSERT INTO country VALUES ('SE','스웨덴','Sweden','SWE','752');
INSERT INTO country VALUES ('CH','스위스','Switzerland','CHE','756');
INSERT INTO country VALUES ('SY','시리아','Syrian Arab Republic','SYR','760');
INSERT INTO country VALUES ('TW','대만','Taiwan, Province of China','TWN','158');
INSERT INTO country VALUES ('TJ','타지키스탄','Tajikistan','TJK','762');
INSERT INTO country VALUES ('TZ','탄자니아, UNITED REPUBLIC OF','Tanzania, United Republic of','TZA','834');
INSERT INTO country VALUES ('TH','타이','Thailand','THA','764');
INSERT INTO country VALUES ('TL','동티모르','Timor-Leste',NULL,NULL);
INSERT INTO country VALUES ('TG','토고','Togo','TGO','768');
INSERT INTO country VALUES ('TK','토켈라우','Tokelau','TKL','772');
INSERT INTO country VALUES ('TO','통가','Tonga','TON','776');
INSERT INTO country VALUES ('TT','트리니다드토바고','Trinidad and Tobago','TTO','780');
INSERT INTO country VALUES ('TN','튀니지','Tunisia','TUN','788');
INSERT INTO country VALUES ('TR','터키','Turkey','TUR','792');
INSERT INTO country VALUES ('TM','투르크메니스탄','Turkmenistan','TKM','795');
INSERT INTO country VALUES ('TC','터크스케이커스제도','Turks and Caicos Islands','TCA','796');
INSERT INTO country VALUES ('TV','투발루','Tuvalu','TUV','798');
INSERT INTO country VALUES ('UG','우간다','Uganda','UGA','800');
INSERT INTO country VALUES ('UA','우크라이나','Ukraine','UKR','804');
INSERT INTO country VALUES ('AE','아랍에미리트','United Arab Emirates','ARE','784');
INSERT INTO country VALUES ('GB','영국','United Kingdom','GBR','826');
INSERT INTO country VALUES ('US','미국','United States','USA','840');
INSERT INTO country VALUES ('UM','마이너 아우들링 합중국 군도','United States Minor Outlying Islands',NULL,NULL);
INSERT INTO country VALUES ('UY','우루과이','Uruguay','URY','858');
INSERT INTO country VALUES ('UZ','우즈베키스탄','Uzbekistan','UZB','860');
INSERT INTO country VALUES ('VU','바누아투','Vanuatu','VUT','548');
INSERT INTO country VALUES ('VE','베네수엘라','Venezuela','VEN','862');
INSERT INTO country VALUES ('VN','베트남','Viet Nam','VNM','704');
INSERT INTO country VALUES ('VG','버진아일랜드(영국령)','Virgin Islands, British','VGB','092');
INSERT INTO country VALUES ('VI','버진아일랜드(미국령)','Virgin Islands, U.s.','VIR','850');
INSERT INTO country VALUES ('WF','왈리스프투나','Wallis and Futuna','WLF','876');
INSERT INTO country VALUES ('EH','서사하라','Western Sahara','ESH','732');
INSERT INTO country VALUES ('YE','예멘','Yemen','YEM','887');
INSERT INTO country VALUES ('ZM','잠비아','Zambia','ZMB','894');
INSERT INTO country VALUES ('ZW','짐바브웨','Zimbabwe','ZWE','716');