ชื่อประเทศ สกุลเงิน รหัสประเทศ ทั่วโลกในฐานข้อมูล mysql MySQL Countries Database


หน้าแรก PHP MySQL เกร็ดความรู้ ชื่อประเทศ สกุลเงิน รหัสประเทศ ทั่วโลกในฐานข้อมูล mysql MySQL Countries Database
รวบรวม รหัสประเทศ ชื่อประเทศ รหัสสกุลเงิน ภาษา ของทุกประเทศทั่วโลก ไว้ใน MySQL Database



  Code

CREATE TABLE IF NOT EXISTS `countries` (
`idCountry` int(5) NOT NULL AUTO_INCREMENT,
`countryCode` char(2) NOT NULL DEFAULT '',
`countryName` varchar(45) NOT NULL DEFAULT '',
`currencyCode` char(3) DEFAULT NULL,
`languages` varchar(30) DEFAULT NULL,
PRIMARY KEY (`idCountry`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=0;

INSERT INTO `countries` (`countryCode`, `countryName`, `currencyCode`, `languages`) VALUES
('AD', 'Andorra', 'EUR', 'ca'),
('AE', 'United Arab Emirates', 'AED', 'ar-AE,fa,en,hi,ur'),
('AF', 'Afghanistan', 'AFN', 'fa-AF,ps,uz-AF,tk'),
('AG', 'Antigua and Barbuda', 'XCD', 'en-AG'),
('AI', 'Anguilla', 'XCD', 'en-AI'),
('AL', 'Albania', 'ALL', 'sq,el'),
('AM', 'Armenia', 'AMD', 'hy'),
('AO', 'Angola', 'AOA', 'pt-AO'),
('AQ', 'Antarctica', '', ''),
('AR', 'Argentina', 'ARS', 'es-AR,en,it,de,fr,gn'),
('AS', 'American Samoa', 'USD', 'en-AS,sm,to'),
('AT', 'Austria', 'EUR', 'de-AT,hr,hu,sl'),
('AU', 'Australia', 'AUD', 'en-AU'),
('AW', 'Aruba', 'AWG', 'nl-AW,es,en'),
('AX', 'Åland', 'EUR', 'sv-AX'),
('AZ', 'Azerbaijan', 'AZN', 'az,ru,hy'),
('BA', 'Bosnia and Herzegovina', 'BAM', 'bs,hr-BA,sr-BA'),
('BB', 'Barbados', 'BBD', 'en-BB'),
('BD', 'Bangladesh', 'BDT', 'bn-BD,en'),
('BE', 'Belgium', 'EUR', 'nl-BE,fr-BE,de-BE'),
('BF', 'Burkina Faso', 'XOF', 'fr-BF'),
('BG', 'Bulgaria', 'BGN', 'bg,tr-BG'),
('BH', 'Bahrain', 'BHD', 'ar-BH,en,fa,ur'),
('BI', 'Burundi', 'BIF', 'fr-BI,rn'),
('BJ', 'Benin', 'XOF', 'fr-BJ'),
('BL', 'Saint Barthélemy', 'EUR', 'fr'),
('BM', 'Bermuda', 'BMD', 'en-BM,pt'),
('BN', 'Brunei', 'BND', 'ms-BN,en-BN'),
('BO', 'Bolivia', 'BOB', 'es-BO,qu,ay'),
('BQ', 'Bonaire', 'USD', 'nl,pap,en'),
('BR', 'Brazil', 'BRL', 'pt-BR,es,en,fr'),
('BS', 'Bahamas', 'BSD', 'en-BS'),
('BT', 'Bhutan', 'BTN', 'dz'),
('BV', 'Bouvet Island', 'NOK', ''),
('BW', 'Botswana', 'BWP', 'en-BW,tn-BW'),
('BY', 'Belarus', 'BYR', 'be,ru'),
('BZ', 'Belize', 'BZD', 'en-BZ,es'),
('CA', 'Canada', 'CAD', 'en-CA,fr-CA,iu'),
('CC', 'Cocos [Keeling] Islands', 'AUD', 'ms-CC,en'),
('CD', 'Democratic Republic of the Congo', 'CDF', 'fr-CD,ln,kg'),
('CF', 'Central African Republic', 'XAF', 'fr-CF,sg,ln,kg'),
('CG', 'Republic of the Congo', 'XAF', 'fr-CG,kg,ln-CG'),
('CH', 'Switzerland', 'CHF', 'de-CH,fr-CH,it-CH,rm'),
('CI', 'Ivory Coast', 'XOF', 'fr-CI'),
('CK', 'Cook Islands', 'NZD', 'en-CK,mi'),
('CL', 'Chile', 'CLP', 'es-CL'),
('CM', 'Cameroon', 'XAF', 'en-CM,fr-CM'),
('CN', 'China', 'CNY', 'zh-CN,yue,wuu,dta,ug,za'),
('CO', 'Colombia', 'COP', 'es-CO'),
('CR', 'Costa Rica', 'CRC', 'es-CR,en'),
('CU', 'Cuba', 'CUP', 'es-CU'),
('CV', 'Cape Verde', 'CVE', 'pt-CV'),
('CW', 'Curacao', 'ANG', 'nl,pap'),
('CX', 'Christmas Island', 'AUD', 'en,zh,ms-CC'),
('CY', 'Cyprus', 'EUR', 'el-CY,tr-CY,en'),
('CZ', 'Czechia', 'CZK', 'cs,sk'),
('DE', 'Germany', 'EUR', 'de'),
('DJ', 'Djibouti', 'DJF', 'fr-DJ,ar,so-DJ,aa'),
('DK', 'Denmark', 'DKK', 'da-DK,en,fo,de-DK'),
('DM', 'Dominica', 'XCD', 'en-DM'),
('DO', 'Dominican Republic', 'DOP', 'es-DO'),
('DZ', 'Algeria', 'DZD', 'ar-DZ'),
('EC', 'Ecuador', 'USD', 'es-EC'),
('EE', 'Estonia', 'EUR', 'et,ru'),
('EG', 'Egypt', 'EGP', 'ar-EG,en,fr'),
('EH', 'Western Sahara', 'MAD', 'ar,mey'),
('ER', 'Eritrea', 'ERN', 'aa-ER,ar,tig,kun,ti-ER'),
('ES', 'Spain', 'EUR', 'es-ES,ca,gl,eu,oc'),
('ET', 'Ethiopia', 'ETB', 'am,en-ET,om-ET,ti-ET,so-ET,sid'),
('FI', 'Finland', 'EUR', 'fi-FI,sv-FI,smn'),
('FJ', 'Fiji', 'FJD', 'en-FJ,fj'),
('FK', 'Falkland Islands', 'FKP', 'en-FK'),
('FM', 'Micronesia', 'USD', 'en-FM,chk,pon,yap,kos,uli,woe,nkr,kpg'),
('FO', 'Faroe Islands', 'DKK', 'fo,da-FO'),
('FR', 'France', 'EUR', 'fr-FR,frp,br,co,ca,eu,oc'),
('GA', 'Gabon', 'XAF', 'fr-GA'),
('GB', 'United Kingdom', 'GBP', 'en-GB,cy-GB,gd'),
('GD', 'Grenada', 'XCD', 'en-GD'),
('GE', 'Georgia', 'GEL', 'ka,ru,hy,az'),
('GF', 'French Guiana', 'EUR', 'fr-GF'),
('GG', 'Guernsey', 'GBP', 'en,fr'),
('GH', 'Ghana', 'GHS', 'en-GH,ak,ee,tw'),
('GI', 'Gibraltar', 'GIP', 'en-GI,es,it,pt'),
('GL', 'Greenland', 'DKK', 'kl,da-GL,en'),
('GM', 'Gambia', 'GMD', 'en-GM,mnk,wof,wo,ff'),
('GN', 'Guinea', 'GNF', 'fr-GN'),
('GP', 'Guadeloupe', 'EUR', 'fr-GP'),
('GQ', 'Equatorial Guinea', 'XAF', 'es-GQ,fr'),
('GR', 'Greece', 'EUR', 'el-GR,en,fr'),
('GS', 'South Georgia and the South Sandwich Islands', 'GBP', 'en'),
('GT', 'Guatemala', 'GTQ', 'es-GT'),
('GU', 'Guam', 'USD', 'en-GU,ch-GU'),
('GW', 'Guinea-Bissau', 'XOF', 'pt-GW,pov'),
('GY', 'Guyana', 'GYD', 'en-GY'),
('HK', 'Hong Kong', 'HKD', 'zh-HK,yue,zh,en'),
('HM', 'Heard Island and McDonald Islands', 'AUD', ''),
('HN', 'Honduras', 'HNL', 'es-HN'),
('HR', 'Croatia', 'HRK', 'hr-HR,sr'),
('HT', 'Haiti', 'HTG', 'ht,fr-HT'),
('HU', 'Hungary', 'HUF', 'hu-HU'),
('ID', 'Indonesia', 'IDR', 'id,en,nl,jv'),
('IE', 'Ireland', 'EUR', 'en-IE,ga-IE'),
('IL', 'Israel', 'ILS', 'he,ar-IL,en-IL,'),
('IM', 'Isle of Man', 'GBP', 'en,gv'),
('IN', 'India', 'INR', 'en-IN,hi,bn,te,mr,ta,ur,gu,kn,ml,or,pa,as,bh,sat,ks,ne,sd,kok,doi,mni,sit,sa,fr,lus,inc'),
('IO', 'British Indian Ocean Territory', 'USD', 'en-IO'),
('IQ', 'Iraq', 'IQD', 'ar-IQ,ku,hy'),
('IR', 'Iran', 'IRR', 'fa-IR,ku'),
('IS', 'Iceland', 'ISK', 'is,en,de,da,sv,no'),
('IT', 'Italy', 'EUR', 'it-IT,de-IT,fr-IT,sc,ca,co,sl'),
('JE', 'Jersey', 'GBP', 'en,pt'),
('JM', 'Jamaica', 'JMD', 'en-JM'),
('JO', 'Jordan', 'JOD', 'ar-JO,en'),
('JP', 'Japan', 'JPY', 'ja'),
('KE', 'Kenya', 'KES', 'en-KE,sw-KE'),
('KG', 'Kyrgyzstan', 'KGS', 'ky,uz,ru'),
('KH', 'Cambodia', 'KHR', 'km,fr,en'),
('KI', 'Kiribati', 'AUD', 'en-KI,gil'),
('KM', 'Comoros', 'KMF', 'ar,fr-KM'),
('KN', 'Saint Kitts and Nevis', 'XCD', 'en-KN'),
('KP', 'North Korea', 'KPW', 'ko-KP'),
('KR', 'South Korea', 'KRW', 'ko-KR,en'),
('KW', 'Kuwait', 'KWD', 'ar-KW,en'),
('KY', 'Cayman Islands', 'KYD', 'en-KY'),
('KZ', 'Kazakhstan', 'KZT', 'kk,ru'),
('LA', 'Laos', 'LAK', 'lo,fr,en'),
('LB', 'Lebanon', 'LBP', 'ar-LB,fr-LB,en,hy'),
('LC', 'Saint Lucia', 'XCD', 'en-LC'),
('LI', 'Liechtenstein', 'CHF', 'de-LI'),
('LK', 'Sri Lanka', 'LKR', 'si,ta,en'),
('LR', 'Liberia', 'LRD', 'en-LR'),
('LS', 'Lesotho', 'LSL', 'en-LS,st,zu,xh'),
('LT', 'Lithuania', 'LTL', 'lt,ru,pl'),
('LU', 'Luxembourg', 'EUR', 'lb,de-LU,fr-LU'),
('LV', 'Latvia', 'LVL', 'lv,ru,lt'),
('LY', 'Libya', 'LYD', 'ar-LY,it,en'),
('MA', 'Morocco', 'MAD', 'ar-MA,fr'),
('MC', 'Monaco', 'EUR', 'fr-MC,en,it'),
('MD', 'Moldova', 'MDL', 'ro,ru,gag,tr'),
('ME', 'Montenegro', 'EUR', 'sr,hu,bs,sq,hr,rom'),
('MF', 'Saint Martin', 'EUR', 'fr'),
('MG', 'Madagascar', 'MGA', 'fr-MG,mg'),
('MH', 'Marshall Islands', 'USD', 'mh,en-MH'),
('MK', 'Macedonia', 'MKD', 'mk,sq,tr,rmm,sr'),
('ML', 'Mali', 'XOF', 'fr-ML,bm'),
('MM', 'Myanmar [Burma]', 'MMK', 'my'),
('MN', 'Mongolia', 'MNT', 'mn,ru'),
('MO', 'Macao', 'MOP', 'zh,zh-MO,pt'),
('MP', 'Northern Mariana Islands', 'USD', 'fil,tl,zh,ch-MP,en-MP'),
('MQ', 'Martinique', 'EUR', 'fr-MQ'),
('MR', 'Mauritania', 'MRO', 'ar-MR,fuc,snk,fr,mey,wo'),
('MS', 'Montserrat', 'XCD', 'en-MS'),
('MT', 'Malta', 'EUR', 'mt,en-MT'),
('MU', 'Mauritius', 'MUR', 'en-MU,bho,fr'),
('MV', 'Maldives', 'MVR', 'dv,en'),
('MW', 'Malawi', 'MWK', 'ny,yao,tum,swk'),
('MX', 'Mexico', 'MXN', 'es-MX'),
('MY', 'Malaysia', 'MYR', 'ms-MY,en,zh,ta,te,ml,pa,th'),
('MZ', 'Mozambique', 'MZN', 'pt-MZ,vmw'),
('NA', 'Namibia', 'NAD', 'en-NA,af,de,hz,naq'),
('NC', 'New Caledonia', 'XPF', 'fr-NC'),
('NE', 'Niger', 'XOF', 'fr-NE,ha,kr,dje'),
('NF', 'Norfolk Island', 'AUD', 'en-NF'),
('NG', 'Nigeria', 'NGN', 'en-NG,ha,yo,ig,ff'),
('NI', 'Nicaragua', 'NIO', 'es-NI,en'),
('NL', 'Netherlands', 'EUR', 'nl-NL,fy-NL'),
('NO', 'Norway', 'NOK', 'no,nb,nn,se,fi'),
('NP', 'Nepal', 'NPR', 'ne,en'),
('NR', 'Nauru', 'AUD', 'na,en-NR'),
('NU', 'Niue', 'NZD', 'niu,en-NU'),
('NZ', 'New Zealand', 'NZD', 'en-NZ,mi'),
('OM', 'Oman', 'OMR', 'ar-OM,en,bal,ur'),
('PA', 'Panama', 'PAB', 'es-PA,en'),
('PE', 'Peru', 'PEN', 'es-PE,qu,ay'),
('PF', 'French Polynesia', 'XPF', 'fr-PF,ty'),
('PG', 'Papua New Guinea', 'PGK', 'en-PG,ho,meu,tpi'),
('PH', 'Philippines', 'PHP', 'tl,en-PH,fil'),
('PK', 'Pakistan', 'PKR', 'ur-PK,en-PK,pa,sd,ps,brh'),
('PL', 'Poland', 'PLN', 'pl'),
('PM', 'Saint Pierre and Miquelon', 'EUR', 'fr-PM'),
('PN', 'Pitcairn Islands', 'NZD', 'en-PN'),
('PR', 'Puerto Rico', 'USD', 'en-PR,es-PR'),
('PS', 'Palestine', 'ILS', 'ar-PS'),
('PT', 'Portugal', 'EUR', 'pt-PT,mwl'),
('PW', 'Palau', 'USD', 'pau,sov,en-PW,tox,ja,fil,zh'),
('PY', 'Paraguay', 'PYG', 'es-PY,gn'),
('QA', 'Qatar', 'QAR', 'ar-QA,es'),
('RE', 'Réunion', 'EUR', 'fr-RE'),
('RO', 'Romania', 'RON', 'ro,hu,rom'),
('RS', 'Serbia', 'RSD', 'sr,hu,bs,rom'),
('RU', 'Russia', 'RUB', 'ru,tt,xal,cau,ady,kv,ce,tyv,cv,udm,tut,mns,bua,myv,mdf,chm,ba,inh,tut,kbd,krc,ava,sah,nog'),
('RW', 'Rwanda', 'RWF', 'rw,en-RW,fr-RW,sw'),
('SA', 'Saudi Arabia', 'SAR', 'ar-SA'),
('SB', 'Solomon Islands', 'SBD', 'en-SB,tpi'),
('SC', 'Seychelles', 'SCR', 'en-SC,fr-SC'),
('SD', 'Sudan', 'SDG', 'ar-SD,en,fia'),
('SE', 'Sweden', 'SEK', 'sv-SE,se,sma,fi-SE'),
('SG', 'Singapore', 'SGD', 'cmn,en-SG,ms-SG,ta-SG,zh-SG'),
('SH', 'Saint Helena', 'SHP', 'en-SH'),
('SI', 'Slovenia', 'EUR', 'sl,sh'),
('SJ', 'Svalbard and Jan Mayen', 'NOK', 'no,ru'),
('SK', 'Slovakia', 'EUR', 'sk,hu'),
('SL', 'Sierra Leone', 'SLL', 'en-SL,men,tem'),
('SM', 'San Marino', 'EUR', 'it-SM'),
('SN', 'Senegal', 'XOF', 'fr-SN,wo,fuc,mnk'),
('SO', 'Somalia', 'SOS', 'so-SO,ar-SO,it,en-SO'),
('SR', 'Suriname', 'SRD', 'nl-SR,en,srn,hns,jv'),
('SS', 'South Sudan', 'SSP', 'en'),
('ST', 'São Tomé and Príncipe', 'STD', 'pt-ST'),
('SV', 'El Salvador', 'USD', 'es-SV'),
('SX', 'Sint Maarten', 'ANG', 'nl,en'),
('SY', 'Syria', 'SYP', 'ar-SY,ku,hy,arc,fr,en'),
('SZ', 'Swaziland', 'SZL', 'en-SZ,ss-SZ'),
('TC', 'Turks and Caicos Islands', 'USD', 'en-TC'),
('TD', 'Chad', 'XAF', 'fr-TD,ar-TD,sre'),
('TF', 'French Southern Territories', 'EUR', 'fr'),
('TG', 'Togo', 'XOF', 'fr-TG,ee,hna,kbp,dag,ha'),
('TH', 'Thailand', 'THB', 'th,en'),
('TJ', 'Tajikistan', 'TJS', 'tg,ru'),
('TK', 'Tokelau', 'NZD', 'tkl,en-TK'),
('TL', 'East Timor', 'USD', 'tet,pt-TL,id,en'),
('TM', 'Turkmenistan', 'TMT', 'tk,ru,uz'),
('TN', 'Tunisia', 'TND', 'ar-TN,fr'),
('TO', 'Tonga', 'TOP', 'to,en-TO'),
('TR', 'Turkey', 'TRY', 'tr-TR,ku,diq,az,av'),
('TT', 'Trinidad and Tobago', 'TTD', 'en-TT,hns,fr,es,zh'),
('TV', 'Tuvalu', 'AUD', 'tvl,en,sm,gil'),
('TW', 'Taiwan', 'TWD', 'zh-TW,zh,nan,hak'),
('TZ', 'Tanzania', 'TZS', 'sw-TZ,en,ar'),
('UA', 'Ukraine', 'UAH', 'uk,ru-UA,rom,pl,hu'),
('UG', 'Uganda', 'UGX', 'en-UG,lg,sw,ar'),
('UM', 'U.S. Minor Outlying Islands', 'USD', 'en-UM'),
('US', 'United States', 'USD', 'en-US,es-US,haw,fr'),
('UY', 'Uruguay', 'UYU', 'es-UY'),
('UZ', 'Uzbekistan', 'UZS', 'uz,ru,tg'),
('VA', 'Vatican City', 'EUR', 'la,it,fr'),
('VC', 'Saint Vincent and the Grenadines', 'XCD', 'en-VC,fr'),
('VE', 'Venezuela', 'VEF', 'es-VE'),
('VG', 'British Virgin Islands', 'USD', 'en-VG'),
('VI', 'U.S. Virgin Islands', 'USD', 'en-VI'),
('VN', 'Vietnam', 'VND', 'vi,en,fr,zh,km'),
('VU', 'Vanuatu', 'VUV', 'bi,en-VU,fr-VU'),
('WF', 'Wallis and Futuna', 'XPF', 'wls,fud,fr-WF'),
('WS', 'Samoa', 'WST', 'sm,en-WS'),
('XK', 'Kosovo', 'EUR', 'sq,sr'),
('YE', 'Yemen', 'YER', 'ar-YE'),
('YT', 'Mayotte', 'EUR', 'fr-YT'),
('ZA', 'South Africa', 'ZAR', 'zu,xh,af,nso,en-ZA,tn,st,ts,ss,ve,nr'),
('ZM', 'Zambia', 'ZMK', 'en-ZM,bem,loz,lun,lue,ny,toi'),
('ZW', 'Zimbabwe', 'ZWL', 'en-ZW,sn,nr,nd')




จาก http://peric.github.io/GetCountries/

ขึ้นไปด้านบน