Ir para conteúdo

Arquivado

Este tópico foi arquivado e está fechado para novas respostas.

fernandoamorim

Banco de dados de Países

Por , em PHP

Recommended Posts

fernandoamorim    0

fernandoamorim
Postado

Dae pessoal...Estava precisando de uma base de dados so de paises....tipoID | NOME | ABREVIAÇÃOALGUEM TEM PODE AE DANDO BOBERA??TE MAIS.

Compartilhar este post

Link para o post
Compartilhar em outros sites

asanoli    0

asanoli
Postado 
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','Afghanistan','AFG','004');INSERT INTO country VALUES ('AL','ALBANIA','Albania','ALB','008');INSERT INTO country VALUES ('DZ','ALGERIA','Algeria','DZA','012');INSERT INTO country VALUES ('AS','AMERICAN SAMOA','American Samoa','ASM','016');INSERT INTO country VALUES ('AD','ANDORRA','Andorra','AND','020');INSERT INTO country VALUES ('AO','ANGOLA','Angola','AGO','024');INSERT INTO country VALUES ('AI','ANGUILLA','Anguilla','AIA','660');INSERT INTO country VALUES ('AQ','ANTARCTICA','Antarctica',NULL,NULL);INSERT INTO country VALUES ('AG','ANTIGUA AND BARBUDA','Antigua and Barbuda','ATG','028');INSERT INTO country VALUES ('AR','ARGENTINA','Argentina','ARG','032');INSERT INTO country VALUES ('AM','ARMENIA','Armenia','ARM','051');INSERT INTO country VALUES ('AW','ARUBA','Aruba','ABW','533');INSERT INTO country VALUES ('AU','AUSTRALIA','Australia','AUS','036');INSERT INTO country VALUES ('AT','AUSTRIA','Austria','AUT','040');INSERT INTO country VALUES ('AZ','AZERBAIJAN','Azerbaijan','AZE','031');INSERT INTO country VALUES ('BS','BAHAMAS','Bahamas','BHS','044');INSERT INTO country VALUES ('BH','BAHRAIN','Bahrain','BHR','048');INSERT INTO country VALUES ('BD','BANGLADESH','Bangladesh','BGD','050');INSERT INTO country VALUES ('BB','BARBADOS','Barbados','BRB','052');INSERT INTO country VALUES ('BY','BELARUS','Belarus','BLR','112');INSERT INTO country VALUES ('BE','BELGIUM','Belgium','BEL','056');INSERT INTO country VALUES ('BZ','BELIZE','Belize','beleza','084');INSERT INTO country VALUES ('BJ','BENIN','Benin','BEN','204');INSERT INTO country VALUES ('BM','BERMUDA','Bermuda','BMU','060');INSERT INTO country VALUES ('BT','BHUTAN','Bhutan','BTN','064');INSERT INTO country VALUES ('BO','BOLIVIA','Bolivia','BOL','068');INSERT INTO country VALUES ('BA','BOSNIA AND HERZEGOVINA','Bosnia and Herzegovina','BIH','070');INSERT INTO country VALUES ('BW','BOTSWANA','Botswana','BWA','072');INSERT INTO country VALUES ('BV','BOUVET ISLAND','Bouvet Island',NULL,NULL);INSERT INTO country VALUES ('BR','BRAZIL','Brazil','BRA','076');INSERT INTO country VALUES ('IO','BRITISH INDIAN OCEAN TERRITORY','British Indian Ocean Territory',NULL,NULL);INSERT INTO country VALUES ('BN','BRUNEI DARUSSALAM','Brunei Darussalam','BRN','096');INSERT INTO country VALUES ('BG','BULGARIA','Bulgaria','BGR','100');INSERT INTO country VALUES ('BF','BURKINA FASO','Burkina Faso','BFA','854');INSERT INTO country VALUES ('BI','BURUNDI','Burundi','BDI','108');INSERT INTO country VALUES ('KH','CAMBODIA','Cambodia','KHM','116');INSERT INTO country VALUES ('CM','CAMEROON','Cameroon','CMR','120');INSERT INTO country VALUES ('CA','CANADA','Canada','CAN','124');INSERT INTO country VALUES ('CV','CAPE VERDE','Cape Verde','CPV','132');INSERT INTO country VALUES ('KY','CAYMAN ISLANDS','Cayman Islands','CYM','136');INSERT INTO country VALUES ('CF','CENTRAL AFRICAN REPUBLIC','Central African Republic','CAF','140');INSERT INTO country VALUES ('TD','CHAD','Chad','TCD','148');INSERT INTO country VALUES ('CL','CHILE','Chile','CHL','152');INSERT INTO country VALUES ('CN','CHINA','China','CHN','156');INSERT INTO country VALUES ('CX','CHRISTMAS ISLAND','Christmas Island',NULL,NULL);INSERT INTO country VALUES ('CC','COCOS (KEELING) ISLANDS','Cocos (Keeling) Islands',NULL,NULL);INSERT INTO country VALUES ('CO','COLOMBIA','Colombia','COL','170');INSERT INTO country VALUES ('KM','COMOROS','Comoros','COM','174');INSERT INTO country VALUES ('CG','CONGO','Congo','COG','178');INSERT INTO country VALUES ('CD','CONGO, THE DEMOCRATIC REPUBLIC OF THE','Congo, the Democratic Republic of the','COD','180');INSERT INTO country VALUES ('CK','COOK ISLANDS','Cook Islands','COK','184');INSERT INTO country VALUES ('CR','COSTA RICA','Costa Rica','CRI','188');INSERT INTO country VALUES ('CI','COTE D\'IVOIRE','Cote D\'Ivoire','CIV','384');INSERT INTO country VALUES ('HR','CROATIA','Croatia','HRV','191');INSERT INTO country VALUES ('c*','CUBA','Cuba','CUB','192');INSERT INTO country VALUES ('CY','CYPRUS','Cyprus','CYP','196');INSERT INTO country VALUES ('CZ','CZECH REPUBLIC','Czech Republic','CZE','203');INSERT INTO country VALUES ('DK','DENMARK','Denmark','DNK','208');INSERT INTO country VALUES ('DJ','DJIBOUTI','Djibouti','DJI','262');INSERT INTO country VALUES ('DM','DOMINICA','Dominica','DMA','212');INSERT INTO country VALUES ('DO','DOMINICAN REPUBLIC','Dominican Republic','DOM','214');INSERT INTO country VALUES ('EC','ECUADOR','Ecuador','ECU','218');INSERT INTO country VALUES ('EG','EGYPT','Egypt','EGY','818');INSERT INTO country VALUES ('SV','EL SALVADOR','El Salvador','SLV','222');INSERT INTO country VALUES ('GQ','EQUATORIAL GUINEA','Equatorial Guinea','GNQ','226');INSERT INTO country VALUES ('ER','ERITREA','Eritrea','ERI','232');INSERT INTO country VALUES ('EE','ESTONIA','Estonia','EST','233');INSERT INTO country VALUES ('ET','ETHIOPIA','Ethiopia','ETH','231');INSERT INTO country VALUES ('FK','FALKLAND ISLANDS (MALVINAS)','Falkland Islands (Malvinas)','FLK','238');INSERT INTO country VALUES ('FO','FAROE ISLANDS','Faroe Islands','FRO','234');INSERT INTO country VALUES ('FJ','FIJI','Fiji','FJI','242');INSERT INTO country VALUES ('FI','FINLAND','Finland','FIN','246');INSERT INTO country VALUES ('FR','FRANCE','France','FRA','250');INSERT INTO country VALUES ('GF','FRENCH GUIANA','French Guiana','GUF','254');INSERT INTO country VALUES ('PF','FRENCH POLYNESIA','French Polynesia','PYF','258');INSERT INTO country VALUES ('TF','FRENCH SOUTHERN TERRITORIES','French Southern Territories',NULL,NULL);INSERT INTO country VALUES ('GA','GABON','Gabon','GAB','266');INSERT INTO country VALUES ('GM','GAMBIA','Gambia','GMB','270');INSERT INTO country VALUES ('GE','GEORGIA','Georgia','GEO','268');INSERT INTO country VALUES ('DE','GERMANY','Germany','DEU','276');INSERT INTO country VALUES ('GH','GHANA','Ghana','GHA','288');INSERT INTO country VALUES ('GI','GIBRALTAR','Gibraltar','GIB','292');INSERT INTO country VALUES ('GR','GREECE','Greece','GRC','300');INSERT INTO country VALUES ('GL','GREENLAND','Greenland','GRL','304');INSERT INTO country VALUES ('GD','GRENADA','Grenada','GRD','308');INSERT INTO country VALUES ('GP','GUADELOUPE','Guadeloupe','GLP','312');INSERT INTO country VALUES ('GU','GUAM','Guam','GUM','316');INSERT INTO country VALUES ('GT','GUATEMALA','Guatemala','GTM','320');INSERT INTO country VALUES ('GN','GUINEA','Guinea','GIN','324');INSERT INTO country VALUES ('GW','GUINEA-BISSAU','Guinea-Bissau','GNB','624');INSERT INTO country VALUES ('GY','GUYANA','Guyana','GUY','328');INSERT INTO country VALUES ('HT','HAITI','Haiti','HTI','332');INSERT INTO country VALUES ('HM','HEARD ISLAND AND MCDONALD ISLANDS','Heard Island and Mcdonald Islands',NULL,NULL);INSERT INTO country VALUES ('VA','HOLY SEE (VATICAN CITY STATE)','Holy See (Vatican City State)','VAT','336');INSERT INTO country VALUES ('HN','HONDURAS','Honduras','HND','340');INSERT INTO country VALUES ('HK','HONG KONG','Hong Kong','HKG','344');INSERT INTO country VALUES ('HU','HUNGARY','Hungary','HUN','348');INSERT INTO country VALUES ('IS','ICELAND','Iceland','ISL','352');INSERT INTO country VALUES ('IN','INDIA','India','IND','356');INSERT INTO country VALUES ('ID','INDONESIA','Indonesia','IDN','360');INSERT INTO country VALUES ('IR','IRAN, ISLAMIC REPUBLIC OF','Iran, Islamic Republic of','IRN','364');INSERT INTO country VALUES ('IQ','IRAQ','Iraq','IRQ','368');INSERT INTO country VALUES ('IE','IRELAND','Ireland','IRL','372');INSERT INTO country VALUES ('IL','ISRAEL','Israel','ISR','376');INSERT INTO country VALUES ('IT','ITALY','Italy','ITA','380');INSERT INTO country VALUES ('JM','JAMAICA','Jamaica','JAM','388');INSERT INTO country VALUES ('JP','JAPAN','Japan','JPN','392');INSERT INTO country VALUES ('JO','JORDAN','Jordan','JOR','400');INSERT INTO country VALUES ('KZ','KAZAKHSTAN','Kazakhstan','KAZ','398');INSERT INTO country VALUES ('KE','KENYA','Kenya','KEN','404');INSERT INTO country VALUES ('KI','KIRIBATI','Kiribati','KIR','296');INSERT INTO country VALUES ('KP','KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF','Korea, Democratic People\'s Republic of','PRK','408');INSERT INTO country VALUES ('KR','KOREA, REPUBLIC OF','Korea, Republic of','KOR','410');INSERT INTO country VALUES ('KW','KUWAIT','Kuwait','KWT','414');INSERT INTO country VALUES ('KG','KYRGYZSTAN','Kyrgyzstan','KGZ','417');INSERT INTO country VALUES ('LA','LAO PEOPLE\'S DEMOCRATIC REPUBLIC','Lao People\'s Democratic Republic','LAO','418');INSERT INTO country VALUES ('LV','LATVIA','Latvia','LVA','428');INSERT INTO country VALUES ('LB','LEBANON','Lebanon','LBN','422');INSERT INTO country VALUES ('LS','LESOTHO','Lesotho','LSO','426');INSERT INTO country VALUES ('LR','LIBERIA','Liberia','LBR','430');INSERT INTO country VALUES ('LY','LIBYAN ARAB JAMAHIRIYA','Libyan Arab Jamahiriya','LBY','434');INSERT INTO country VALUES ('LI','LIECHTENSTEIN','Liechtenstein','LIE','438');INSERT INTO country VALUES ('LT','LITHUANIA','Lithuania','LTU','440');INSERT INTO country VALUES ('LU','LUXEMBOURG','Luxembourg','LUX','442');INSERT INTO country VALUES ('MO','MACAO','Macao','MAC','446');INSERT INTO country VALUES ('MK','MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF','Macedonia, the Former Yugoslav Republic of','MKD','807');INSERT INTO country VALUES ('MG','MADAGASCAR','Madagascar','MDG','450');INSERT INTO country VALUES ('MW','MALAWI','Malawi','MWI','454');INSERT INTO country VALUES ('MY','MALAYSIA','Malaysia','MYS','458');INSERT INTO country VALUES ('MV','MALDIVES','Maldives','MDV','462');INSERT INTO country VALUES ('ML','MALI','Mali','MLI','466');INSERT INTO country VALUES ('MT','MALTA','Malta','MLT','470');INSERT INTO country VALUES ('MH','MARSHALL ISLANDS','Marshall Islands','MHL','584');INSERT INTO country VALUES ('MQ','MARTINIQUE','Martinique','MTQ','474');INSERT INTO country VALUES ('MR','MAURITANIA','Mauritania','MRT','478');INSERT INTO country VALUES ('MU','MAURITIUS','Mauritius','MUS','480');INSERT INTO country VALUES ('YT','MAYOTTE','Mayotte',NULL,NULL);INSERT INTO country VALUES ('MX','MEXICO','Mexico','MEX','484');INSERT INTO country VALUES ('FM','MICRONESIA, FEDERATED STATES OF','Micronesia, Federated States of','FSM','583');INSERT INTO country VALUES ('MD','MOLDOVA, REPUBLIC OF','Moldova, Republic of','MDA','498');INSERT INTO country VALUES ('MC','MONACO','Monaco','MCO','492');INSERT INTO country VALUES ('MN','MONGOLIA','Mongolia','MNG','496');INSERT INTO country VALUES ('MS','MONTSERRAT','Montserrat','MSR','500');INSERT INTO country VALUES ('MA','MOROCCO','Morocco','MAR','504');INSERT INTO country VALUES ('MZ','MOZAMBIQUE','Mozambique','MOZ','508');INSERT INTO country VALUES ('MM','MYANMAR','Myanmar','MMR','104');INSERT INTO country VALUES ('NA','NAMIBIA','Namibia','NAM','516');INSERT INTO country VALUES ('NR','NAURU','Nauru','NRU','520');INSERT INTO country VALUES ('NP','NEPAL','Nepal','NPL','524');INSERT INTO country VALUES ('NL','NETHERLANDS','Netherlands','NLD','528');INSERT INTO country VALUES ('AN','NETHERLANDS ANTILLES','Netherlands Antilles','ANT','530');INSERT INTO country VALUES ('NC','NEW CALEDONIA','New Caledonia','NCL','540');INSERT INTO country VALUES ('NZ','NEW ZEALAND','New Zealand','NZL','554');INSERT INTO country VALUES ('NI','NICARAGUA','Nicaragua','NIC','558');INSERT INTO country VALUES ('NE','NIGER','Niger','NER','562');INSERT INTO country VALUES ('NG','NIGERIA','Nigeria','NGA','566');INSERT INTO country VALUES ('NU','NIUE','Niue','NIU','570');INSERT INTO country VALUES ('NF','NORFOLK ISLAND','Norfolk Island','NFK','574');INSERT INTO country VALUES ('MP','NORTHERN MARIANA ISLANDS','Northern Mariana Islands','MNP','580');INSERT INTO country VALUES ('NO','NORWAY','Norway','NOR','578');INSERT INTO country VALUES ('OM','OMAN','Oman','OMN','512');INSERT INTO country VALUES ('PK','PAKISTAN','Pakistan','PAK','586');INSERT INTO country VALUES ('PW','PALAU','Palau','PLW','585');INSERT INTO country VALUES ('PS','PALESTINIAN TERRITORY, OCCUPIED','Palestinian Territory, Occupied',NULL,NULL);INSERT INTO country VALUES ('PA','PANAMA','Panama','PAN','591');INSERT INTO country VALUES ('PG','PAPUA NEW GUINEA','Papua New Guinea','PNG','598');INSERT INTO country VALUES ('PY','PARAGUAY','Paraguay','PRY','600');INSERT INTO country VALUES ('PE','PERU','Peru','PER','604');INSERT INTO country VALUES ('PH','PHILIPPINES','Philippines','PHL','608');INSERT INTO country VALUES ('PN','PITCAIRN','Pitcairn','PCN','612');INSERT INTO country VALUES ('PL','POLAND','Poland','POL','616');INSERT INTO country VALUES ('PT','PORTUGAL','Portugal','PRT','620');INSERT INTO country VALUES ('PR','PUERTO RICO','Puerto Rico','PRI','630');INSERT INTO country VALUES ('QA','QATAR','Qatar','QAT','634');INSERT INTO country VALUES ('RE','REUNION','Reunion','REU','638');INSERT INTO country VALUES ('RO','ROMANIA','Romania','ROM','642');INSERT INTO country VALUES ('RU','RUSSIAN FEDERATION','Russian Federation','RUS','643');INSERT INTO country VALUES ('RW','RWANDA','Rwanda','RWA','646');INSERT INTO country VALUES ('SH','SAINT HELENA','Saint Helena','SHN','654');INSERT INTO country VALUES ('KN','SAINT KITTS AND NEVIS','Saint Kitts and Nevis','KNA','659');INSERT INTO country VALUES ('LC','SAINT LUCIA','Saint Lucia','LCA','662');INSERT INTO country VALUES ('PM','SAINT PIERRE AND MIQUELON','Saint Pierre and Miquelon','SPM','666');INSERT INTO country VALUES ('você','SAINT VINCENT AND THE GRENADINES','Saint Vincent and the Grenadines','VCT','670');INSERT INTO country VALUES ('WS','SAMOA','Samoa','WSM','882');INSERT INTO country VALUES ('SM','SAN MARINO','San Marino','SMR','674');INSERT INTO country VALUES ('ST','SAO TOME AND PRINCIPE','Sao Tome and Principe','STP','678');INSERT INTO country VALUES ('SA','SAUDI ARABIA','Saudi Arabia','SAU','682');INSERT INTO country VALUES ('SN','SENEGAL','Senegal','SEN','686');INSERT INTO country VALUES ('CS','SERBIA AND MONTENEGRO','Serbia and Montenegro',NULL,NULL);INSERT INTO country VALUES ('SC','SEYCHELLES','Seychelles','SYC','690');INSERT INTO country VALUES ('SL','SIERRA LEONE','Sierra Leone','SLE','694');INSERT INTO country VALUES ('SG','SINGAPORE','Singapore','SGP','702');INSERT INTO country VALUES ('SK','SLOVAKIA','Slovakia','SVK','703');INSERT INTO country VALUES ('SI','SLOVENIA','Slovenia','SVN','705');INSERT INTO country VALUES ('SB','SOLOMON ISLANDS','Solomon Islands','SLB','090');INSERT INTO country VALUES ('SO','SOMALIA','Somalia','SOM','706');INSERT INTO country VALUES ('ZA','SOUTH AFRICA','South Africa','ZAF','710');INSERT INTO country VALUES ('GS','SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS','South Georgia and the South Sandwich Islands',NULL,NULL);INSERT INTO country VALUES ('ES','SPAIN','Spain','ESP','724');INSERT INTO country VALUES ('LK','SRI LANKA','Sri Lanka','LKA','144');INSERT INTO country VALUES ('SD','SUDAN','Sudan','SDN','736');INSERT INTO country VALUES ('SR','SURINAME','Suriname','SUR','740');INSERT INTO country VALUES ('SJ','SVALBARD AND JAN MAYEN','Svalbard and Jan Mayen','SJM','744');INSERT INTO country VALUES ('SZ','SWAZILAND','Swaziland','SWZ','748');INSERT INTO country VALUES ('SE','SWEDEN','Sweden','SWE','752');INSERT INTO country VALUES ('CH','SWITZERLAND','Switzerland','CHE','756');INSERT INTO country VALUES ('SY','SYRIAN ARAB REPUBLIC','Syrian Arab Republic','SYR','760');INSERT INTO country VALUES ('TW','TAIWAN, PROVINCE OF CHINA','Taiwan, Province of China','TWN','158');INSERT INTO country VALUES ('TJ','TAJIKISTAN','Tajikistan','TJK','762');INSERT INTO country VALUES ('TZ','TANZANIA, UNITED REPUBLIC OF','Tanzania, United Republic of','TZA','834');INSERT INTO country VALUES ('TH','THAILAND','Thailand','THA','764');INSERT INTO country VALUES ('TL','TIMOR-LESTE','Timor-Leste',NULL,NULL);INSERT INTO country VALUES ('TG','TOGO','Togo','TGO','768');INSERT INTO country VALUES ('TK','TOKELAU','Tokelau','TKL','772');INSERT INTO country VALUES ('TO','TONGA','Tonga','TON','776');INSERT INTO country VALUES ('TT','TRINIDAD AND TOBAGO','Trinidad and Tobago','TTO','780');INSERT INTO country VALUES ('TN','TUNISIA','Tunisia','TUN','788');INSERT INTO country VALUES ('TR','TURKEY','Turkey','TUR','792');INSERT INTO country VALUES ('TM','TURKMENISTAN','Turkmenistan','TKM','795');INSERT INTO country VALUES ('TC','TURKS AND CAICOS ISLANDS','Turks and Caicos Islands','TCA','796');INSERT INTO country VALUES ('TV','TUVALU','Tuvalu','TUV','798');INSERT INTO country VALUES ('UG','UGANDA','Uganda','UGA','800');INSERT INTO country VALUES ('UA','UKRAINE','Ukraine','UKR','804');INSERT INTO country VALUES ('AE','UNITED ARAB EMIRATES','United Arab Emirates','ARE','784');INSERT INTO country VALUES ('GB','UNITED KINGDOM','United Kingdom','GBR','826');INSERT INTO country VALUES ('US','UNITED STATES','United States','USA','840');INSERT INTO country VALUES ('UM','UNITED STATES MINOR OUTLYING ISLANDS','United States Minor Outlying Islands',NULL,NULL);INSERT INTO country VALUES ('UY','URUGUAY','Uruguay','URY','858');INSERT INTO country VALUES ('UZ','UZBEKISTAN','Uzbekistan','UZB','860');INSERT INTO country VALUES ('VU','VANUATU','Vanuatu','VUT','548');INSERT INTO country VALUES ('VE','VENEZUELA','Venezuela','VEN','862');INSERT INTO country VALUES ('VN','VIET NAM','Viet Nam','VNM','704');INSERT INTO country VALUES ('VG','VIRGIN ISLANDS, BRITISH','Virgin Islands, British','VGB','092');INSERT INTO country VALUES ('VI','VIRGIN ISLANDS, U.S.','Virgin Islands, U.s.','VIR','850');INSERT INTO country VALUES ('WF','WALLIS AND FUTUNA','Wallis and Futuna','WLF','876');INSERT INTO country VALUES ('EH','WESTERN SAHARA','Western Sahara','ESH','732');INSERT INTO country VALUES ('YE','YEMEN','Yemen','YEM','887');INSERT INTO country VALUES ('ZM','ZAMBIA','Zambia','ZMB','894');INSERT INTO country VALUES ('ZW','ZIMBABWE','Zimbabwe','ZWE','716');

Compartilhar este post

Link para o post
Compartilhar em outros sites

P3rukao    0

P3rukao
Postado

Encontrei esta:

 

CREATE TABLE paises (
 iso CHAR(2) NOT NULL PRIMARY KEY,
 iso3 char(3) NOT NULL,
 numcode SMALLINT,
 nome VARCHAR(255) NOT NULL
);
INSERT INTO paises VALUES ('AF', 'AFG', '004', 'Afeganistão');
INSERT INTO paises VALUES ('ZA', 'ZAF', '710', 'África do Sul');
INSERT INTO paises VALUES ('AX', 'ALA', '248', 'Åland, Ilhas');
INSERT INTO paises VALUES ('AL', 'ALB', '008', 'Albânia');
INSERT INTO paises VALUES ('DE', 'DEU', '276', 'Alemanha');
INSERT INTO paises VALUES ('AD', 'AND', '020', 'Andorra');
INSERT INTO paises VALUES ('AO', 'AGO', '024', 'Angola');
INSERT INTO paises VALUES ('AI', 'AIA', '660', 'Anguilla');
INSERT INTO paises VALUES ('AQ', 'ATA', '010', 'Antárctida');
INSERT INTO paises VALUES ('AG', 'ATG', '028', 'Antigua e Barbuda');
INSERT INTO paises VALUES ('AN', 'ANT', '530', 'Antilhas Holandesas');
INSERT INTO paises VALUES ('SA', 'SAU', '682', 'Arábia Saudita');
INSERT INTO paises VALUES ('DZ', 'DZA', '012', 'Argélia');
INSERT INTO paises VALUES ('AR', 'ARG', '032', 'Argentina');
INSERT INTO paises VALUES ('AM', 'ARM', '051', 'Arménia');
INSERT INTO paises VALUES ('AW', 'ABW', '533', 'Aruba');
INSERT INTO paises VALUES ('AU', 'AUS', '036', 'Austrália');
INSERT INTO paises VALUES ('AT', 'AUT', '040', 'Áustria');
INSERT INTO paises VALUES ('AZ', 'AZE', '031', 'Azerbeijão');
INSERT INTO paises VALUES ('BS', 'BHS', '044', 'Bahamas');
INSERT INTO paises VALUES ('BH', 'BHR', '048', 'Bahrain');
INSERT INTO paises VALUES ('BD', 'BGD', '050', 'Bangladesh');
INSERT INTO paises VALUES ('BB', 'BRB', '052', 'Barbados');
INSERT INTO paises VALUES ('BE', 'BEL', '056', 'Bélgica');
INSERT INTO paises VALUES ('BZ', 'beleza', '084', 'Belize');
INSERT INTO paises VALUES ('BJ', 'BEN', '204', 'Benin');
INSERT INTO paises VALUES ('BM', 'BMU', '060', 'Bermuda');
INSERT INTO paises VALUES ('BY', 'BLR', '112', 'Bielo-Rússia');
INSERT INTO paises VALUES ('BO', 'BOL', '068', 'Bolívia');
INSERT INTO paises VALUES ('BA', 'BIH', '070', 'Bósnia-Herzegovina');
INSERT INTO paises VALUES ('BW', 'BWA', '072', 'Botswana');
INSERT INTO paises VALUES ('BV', 'BVT', '074', 'Bouvet, Ilha');
INSERT INTO paises VALUES ('BR', 'BRA', '076', 'Brasil');
INSERT INTO paises VALUES ('BN', 'BRN', '096', 'Brunei');
INSERT INTO paises VALUES ('BG', 'BGR', '100', 'Bulgária');
INSERT INTO paises VALUES ('BF', 'BFA', '854', 'Burkina Faso');
INSERT INTO paises VALUES ('BI', 'BDI', '108', 'Burundi');
INSERT INTO paises VALUES ('BT', 'BTN', '064', 'Butão');
INSERT INTO paises VALUES ('CV', 'CPV', '132', 'Cabo Verde');
INSERT INTO paises VALUES ('KH', 'KHM', '116', 'Cambodja');
INSERT INTO paises VALUES ('CM', 'CMR', '120', 'Camarões');
INSERT INTO paises VALUES ('CA', 'CAN', '124', 'Canadá');
INSERT INTO paises VALUES ('KY', 'CYM', '136', 'Cayman, Ilhas');
INSERT INTO paises VALUES ('KZ', 'KAZ', '398', 'Cazaquistão');
INSERT INTO paises VALUES ('CF', 'CAF', '140', 'Centro-africana, República');
INSERT INTO paises VALUES ('TD', 'TCD', '148', 'Chade');
INSERT INTO paises VALUES ('CZ', 'CZE', '203', 'Checa, República');
INSERT INTO paises VALUES ('CL', 'CHL', '152', 'Chile');
INSERT INTO paises VALUES ('CN', 'CHN', '156', 'China');
INSERT INTO paises VALUES ('CY', 'CYP', '196', 'Chipre');
INSERT INTO paises VALUES ('CX', 'CXR', '162', 'Christmas, Ilha');
INSERT INTO paises VALUES ('CC', 'CCK', '166', 'Cocos, Ilhas');
INSERT INTO paises VALUES ('CO', 'COL', '170', 'Colômbia');
INSERT INTO paises VALUES ('KM', 'COM', '174', 'Comores');
INSERT INTO paises VALUES ('CG', 'COG', '178', 'Congo, República do');
INSERT INTO paises VALUES ('CD', 'COD', '180', 'Congo, República Democrática do (antigo Zaire)');
INSERT INTO paises VALUES ('CK', 'COK', '184', 'Cook, Ilhas');
INSERT INTO paises VALUES ('KR', 'KOR', '410', 'Coreia do Sul');
INSERT INTO paises VALUES ('KP', 'PRK', '408', 'Coreia, República Democrática da (Coreia do Norte)');
INSERT INTO paises VALUES ('CI', 'CIV', '384', 'Costa do Marfim');
INSERT INTO paises VALUES ('CR', 'CRI', '188', 'Costa Rica');
INSERT INTO paises VALUES ('HR', 'HRV', '191', 'Croácia');
INSERT INTO paises VALUES ('c*', 'CUB', '192', 'Cuba');
INSERT INTO paises VALUES ('DK', 'DNK', '208', 'Dinamarca');
INSERT INTO paises VALUES ('DJ', 'DJI', '262', 'Djibouti');
INSERT INTO paises VALUES ('DM', 'DMA', '212', 'Dominica');
INSERT INTO paises VALUES ('DO', 'DOM', '214', 'Dominicana, República');
INSERT INTO paises VALUES ('EG', 'EGY', '818', 'Egipto');
INSERT INTO paises VALUES ('SV', 'SLV', '222', 'El Salvador');
INSERT INTO paises VALUES ('AE', 'ARE', '784', 'Emiratos Árabes Unidos');
INSERT INTO paises VALUES ('EC', 'ECU', '218', 'Equador');
INSERT INTO paises VALUES ('ER', 'ERI', '232', 'Eritreia');
INSERT INTO paises VALUES ('SK', 'SVK', '703', 'Eslováquia');
INSERT INTO paises VALUES ('SI', 'SVN', '705', 'Eslovénia');
INSERT INTO paises VALUES ('ES', 'ESP', '724', 'Espanha');
INSERT INTO paises VALUES ('US', 'USA', '840', 'Estados Unidos da América');
INSERT INTO paises VALUES ('EE', 'EST', '233', 'Estónia');
INSERT INTO paises VALUES ('ET', 'ETH', '231', 'Etiópia');
INSERT INTO paises VALUES ('FO', 'FRO', '234', 'Faroe, Ilhas');
INSERT INTO paises VALUES ('FJ', 'FJI', '242', 'Fiji');
INSERT INTO paises VALUES ('PH', 'PHL', '608', 'Filipinas');
INSERT INTO paises VALUES ('FI', 'FIN', '246', 'Finlândia');
INSERT INTO paises VALUES ('FR', 'FRA', '250', 'França');
INSERT INTO paises VALUES ('GA', 'GAB', '266', 'Gabão');
INSERT INTO paises VALUES ('GM', 'GMB', '270', 'Gâmbia');
INSERT INTO paises VALUES ('GH', 'GHA', '288', 'Gana');
INSERT INTO paises VALUES ('GE', 'GEO', '268', 'Geórgia');
INSERT INTO paises VALUES ('GS', 'SGS', '239', 'Geórgia do Sul e Sandwich do Sul, Ilhas');
INSERT INTO paises VALUES ('GI', 'GIB', '292', 'Gibraltar');
INSERT INTO paises VALUES ('GR', 'GRC', '300', 'Grécia');
INSERT INTO paises VALUES ('GD', 'GRD', '308', 'Grenada');
INSERT INTO paises VALUES ('GL', 'GRL', '304', 'Gronelândia');
INSERT INTO paises VALUES ('GP', 'GLP', '312', 'Guadeloupe');
INSERT INTO paises VALUES ('GU', 'GUM', '316', 'Guam');
INSERT INTO paises VALUES ('GT', 'GTM', '320', 'Guatemala');
INSERT INTO paises VALUES ('GG', 'GGY', '831', 'Guernsey');
INSERT INTO paises VALUES ('GY', 'GUY', '328', 'Guiana');
INSERT INTO paises VALUES ('GF', 'GUF', '254', 'Guiana Francesa');
INSERT INTO paises VALUES ('GW', 'GNB', '624', 'Guiné-Bissau');
INSERT INTO paises VALUES ('GN', 'GIN', '324', 'Guiné-Conacri');
INSERT INTO paises VALUES ('GQ', 'GNQ', '226', 'Guiné Equatorial');
INSERT INTO paises VALUES ('HT', 'HTI', '332', 'Haiti');
INSERT INTO paises VALUES ('HM', 'HMD', '334', 'Heard e Ilhas McDonald, Ilha');
INSERT INTO paises VALUES ('HN', 'HND', '340', 'Honduras');
INSERT INTO paises VALUES ('HK', 'HKG', '344', 'Hong Kong');
INSERT INTO paises VALUES ('HU', 'HUN', '348', 'Hungria');
INSERT INTO paises VALUES ('YE', 'YEM', '887', 'Iémen');
INSERT INTO paises VALUES ('IN', 'IND', '356', 'Índia');
INSERT INTO paises VALUES ('ID', 'IDN', '360', 'Indonésia');
INSERT INTO paises VALUES ('IQ', 'IRQ', '368', 'Iraque');
INSERT INTO paises VALUES ('IR', 'IRN', '364', 'Irão');
INSERT INTO paises VALUES ('IE', 'IRL', '372', 'Irlanda');
INSERT INTO paises VALUES ('IS', 'ISL', '352', 'Islândia');
INSERT INTO paises VALUES ('IL', 'ISR', '376', 'Israel');
INSERT INTO paises VALUES ('IT', 'ITA', '380', 'Itália');
INSERT INTO paises VALUES ('JM', 'JAM', '388', 'Jamaica');
INSERT INTO paises VALUES ('JP', 'JPN', '392', 'Japão');
INSERT INTO paises VALUES ('JE', 'JEY', '832', 'Jersey');
INSERT INTO paises VALUES ('JO', 'JOR', '400', 'Jordânia');
INSERT INTO paises VALUES ('KI', 'KIR', '296', 'Kiribati');
INSERT INTO paises VALUES ('KW', 'KWT', '414', 'Kuwait');
INSERT INTO paises VALUES ('LA', 'LAO', '418', 'Laos');
INSERT INTO paises VALUES ('LS', 'LSO', '426', 'Lesoto');
INSERT INTO paises VALUES ('LV', 'LVA', '428', 'Letónia');
INSERT INTO paises VALUES ('LB', 'LBN', '422', 'Líbano');
INSERT INTO paises VALUES ('LR', 'LBR', '430', 'Libéria');
INSERT INTO paises VALUES ('LY', 'LBY', '434', 'Líbia');
INSERT INTO paises VALUES ('LI', 'LIE', '438', 'Liechtenstein');
INSERT INTO paises VALUES ('LT', 'LTU', '440', 'Lituânia');
INSERT INTO paises VALUES ('LU', 'LUX', '442', 'Luxemburgo');
INSERT INTO paises VALUES ('MO', 'MAC', '446', 'Macau');
INSERT INTO paises VALUES ('MK', 'MKD', '807', 'Macedónia, República da');
INSERT INTO paises VALUES ('MG', 'MDG', '450', 'Madagáscar');
INSERT INTO paises VALUES ('MY', 'MYS', '458', 'Malásia');
INSERT INTO paises VALUES ('MW', 'MWI', '454', 'Malawi');
INSERT INTO paises VALUES ('MV', 'MDV', '462', 'Maldivas');
INSERT INTO paises VALUES ('ML', 'MLI', '466', 'Mali');
INSERT INTO paises VALUES ('MT', 'MLT', '470', 'Malta');
INSERT INTO paises VALUES ('FK', 'FLK', '238', 'Malvinas, Ilhas (Falkland)');
INSERT INTO paises VALUES ('IM', 'IMN', '833', 'Man, Ilha de');
INSERT INTO paises VALUES ('MP', 'MNP', '580', 'Marianas Setentrionais');
INSERT INTO paises VALUES ('MA', 'MAR', '504', 'Marrocos');
INSERT INTO paises VALUES ('MH', 'MHL', '584', 'Marshall, Ilhas');
INSERT INTO paises VALUES ('MQ', 'MTQ', '474', 'Martinica');
INSERT INTO paises VALUES ('MU', 'MUS', '480', 'Maurícia');
INSERT INTO paises VALUES ('MR', 'MRT', '478', 'Mauritânia');
INSERT INTO paises VALUES ('YT', 'MYT', '175', 'Mayotte');
INSERT INTO paises VALUES ('UM', 'UMI', '581', 'Menores Distantes dos Estados Unidos, Ilhas');
INSERT INTO paises VALUES ('MX', 'MEX', '484', 'México');
INSERT INTO paises VALUES ('MM', 'MMR', '104', 'Myanmar (antiga Birmânia)');
INSERT INTO paises VALUES ('FM', 'FSM', '583', 'Micronésia, Estados Federados da');
INSERT INTO paises VALUES ('MZ', 'MOZ', '508', 'Moçambique');
INSERT INTO paises VALUES ('MD', 'MDA', '498', 'Moldávia');
INSERT INTO paises VALUES ('MC', 'MCO', '492', 'Mónaco');
INSERT INTO paises VALUES ('MN', 'MNG', '496', 'Mongólia');
INSERT INTO paises VALUES ('ME', 'MNE', '499', 'Montenegro');
INSERT INTO paises VALUES ('MS', 'MSR', '500', 'Montserrat');
INSERT INTO paises VALUES ('NA', 'NAM', '516', 'Namíbia');
INSERT INTO paises VALUES ('NR', 'NRU', '520', 'Nauru');
INSERT INTO paises VALUES ('NP', 'NPL', '524', 'Nepal');
INSERT INTO paises VALUES ('NI', 'NIC', '558', 'Nicarágua');
INSERT INTO paises VALUES ('NE', 'NER', '562', 'Níger');
INSERT INTO paises VALUES ('NG', 'NGA', '566', 'Nigéria');
INSERT INTO paises VALUES ('NU', 'NIU', '570', 'Niue');
INSERT INTO paises VALUES ('NF', 'NFK', '574', 'Norfolk, Ilha');
INSERT INTO paises VALUES ('NO', 'NOR', '578', 'Noruega');
INSERT INTO paises VALUES ('NC', 'NCL', '540', 'Nova Caledónia');
INSERT INTO paises VALUES ('NZ', 'NZL', '554', 'Nova Zelândia (Aotearoa)');
INSERT INTO paises VALUES ('OM', 'OMN', '512', 'Oman');
INSERT INTO paises VALUES ('NL', 'NLD', '528', 'Países Baixos (Holanda)');
INSERT INTO paises VALUES ('PW', 'PLW', '585', 'Palau');
INSERT INTO paises VALUES ('PS', 'PSE', '275', 'Palestina');
INSERT INTO paises VALUES ('PA', 'PAN', '591', 'Panamá');
INSERT INTO paises VALUES ('PG', 'PNG', '598', 'Papua-Nova Guiné');
INSERT INTO paises VALUES ('PK', 'PAK', '586', 'Paquistão');
INSERT INTO paises VALUES ('PY', 'PRY', '600', 'Paraguai');
INSERT INTO paises VALUES ('PE', 'PER', '604', 'Peru');
INSERT INTO paises VALUES ('PN', 'PCN', '612', 'Pitcairn');
INSERT INTO paises VALUES ('PF', 'PYF', '258', 'Polinésia Francesa');
INSERT INTO paises VALUES ('PL', 'POL', '616', 'Polónia');
INSERT INTO paises VALUES ('PR', 'PRI', '630', 'Porto Rico');
INSERT INTO paises VALUES ('PT', 'PRT', '620', 'Portugal');
INSERT INTO paises VALUES ('QA', 'QAT', '634', 'Qatar');
INSERT INTO paises VALUES ('KE', 'KEN', '404', 'Quénia');
INSERT INTO paises VALUES ('KG', 'KGZ', '417', 'Quirguistão');
INSERT INTO paises VALUES ('GB', 'GBR', '826', 'Reino Unido da Grã-Bretanha e Irlanda do Norte');
INSERT INTO paises VALUES ('RE', 'REU', '638', 'Reunião');
INSERT INTO paises VALUES ('RO', 'ROU', '642', 'Roménia');
INSERT INTO paises VALUES ('RW', 'RWA', '646', 'Ruanda');
INSERT INTO paises VALUES ('RU', 'RUS', '643', 'Rússia');
INSERT INTO paises VALUES ('EH', 'ESH', '732', 'Saara Ocidental');
INSERT INTO paises VALUES ('AS', 'ASM', '016', 'Samoa Americana');
INSERT INTO paises VALUES ('WS', 'WSM', '882', 'Samoa (Samoa Ocidental)');
INSERT INTO paises VALUES ('PM', 'SPM', '666', 'Saint Pierre et Miquelon');
INSERT INTO paises VALUES ('SB', 'SLB', '090', 'Salomão, Ilhas');
INSERT INTO paises VALUES ('KN', 'KNA', '659', 'São Cristóvão e Névis (Saint Kitts e Nevis)');
INSERT INTO paises VALUES ('SM', 'SMR', '674', 'San Marino');
INSERT INTO paises VALUES ('ST', 'STP', '678', 'São Tomé e Príncipe');
INSERT INTO paises VALUES ('você', 'VCT', '670', 'São Vicente e Granadinas');
INSERT INTO paises VALUES ('SH', 'SHN', '654', 'Santa Helena');
INSERT INTO paises VALUES ('LC', 'LCA', '662', 'Santa Lúcia');
INSERT INTO paises VALUES ('SN', 'SEN', '686', 'Senegal');
INSERT INTO paises VALUES ('SL', 'SLE', '694', 'Serra Leoa');
INSERT INTO paises VALUES ('RS', 'SRB', '688', 'Sérvia');
INSERT INTO paises VALUES ('SC', 'SYC', '690', 'Seychelles');
INSERT INTO paises VALUES ('SG', 'SGP', '702', 'Singapura');
INSERT INTO paises VALUES ('SY', 'SYR', '760', 'Síria');
INSERT INTO paises VALUES ('SO', 'SOM', '706', 'Somália');
INSERT INTO paises VALUES ('LK', 'LKA', '144', 'Sri Lanka');
INSERT INTO paises VALUES ('SZ', 'SWZ', '748', 'Suazilândia');
INSERT INTO paises VALUES ('SD', 'SDN', '736', 'Sudão');
INSERT INTO paises VALUES ('SE', 'SWE', '752', 'Suécia');
INSERT INTO paises VALUES ('CH', 'CHE', '756', 'Suíça');
INSERT INTO paises VALUES ('SR', 'SUR', '740', 'Suriname');
INSERT INTO paises VALUES ('SJ', 'SJM', '744', 'Svalbard e Jan Mayen');
INSERT INTO paises VALUES ('TH', 'THA', '764', 'Tailândia');
INSERT INTO paises VALUES ('TW', 'TWN', '158', 'Taiwan');
INSERT INTO paises VALUES ('TJ', 'TJK', '762', 'Tajiquistão');
INSERT INTO paises VALUES ('TZ', 'TZA', '834', 'Tanzânia');
INSERT INTO paises VALUES ('TF', 'ATF', '260', 'Terras Austrais e Antárticas Francesas (TAAF)');
INSERT INTO paises VALUES ('IO', 'IOT', '086', 'Território Britânico do Oceano Índico');
INSERT INTO paises VALUES ('TL', 'TLS', '626', 'Timor-Leste');
INSERT INTO paises VALUES ('TG', 'TGO', '768', 'Togo');
INSERT INTO paises VALUES ('TK', 'TKL', '772', 'Toquelau');
INSERT INTO paises VALUES ('TO', 'TON', '776', 'Tonga');
INSERT INTO paises VALUES ('TT', 'TTO', '780', 'Trindade e Tobago');
INSERT INTO paises VALUES ('TN', 'TUN', '788', 'Tunísia');
INSERT INTO paises VALUES ('TC', 'TCA', '796', 'Turks e Caicos');
INSERT INTO paises VALUES ('TM', 'TKM', '795', 'Turquemenistão');
INSERT INTO paises VALUES ('TR', 'TUR', '792', 'Turquia');
INSERT INTO paises VALUES ('TV', 'TUV', '798', 'Tuvalu');
INSERT INTO paises VALUES ('UA', 'UKR', '804', 'Ucrânia');
INSERT INTO paises VALUES ('UG', 'UGA', '800', 'Uganda');
INSERT INTO paises VALUES ('UY', 'URY', '858', 'Uruguai');
INSERT INTO paises VALUES ('UZ', 'UZB', '860', 'Usbequistão');
INSERT INTO paises VALUES ('VU', 'VUT', '548', 'Vanuatu');
INSERT INTO paises VALUES ('VA', 'VAT', '336', 'Vaticano');
INSERT INTO paises VALUES ('VE', 'VEN', '862', 'Venezuela');
INSERT INTO paises VALUES ('VN', 'VNM', '704', 'Vietname');
INSERT INTO paises VALUES ('VI', 'VIR', '850', 'Virgens Americanas, Ilhas');
INSERT INTO paises VALUES ('VG', 'VGB', '092', 'Virgens Britânicas, Ilhas');
INSERT INTO paises VALUES ('WF', 'WLF', '876', 'Wallis e Futuna');
INSERT INTO paises VALUES ('ZM', 'ZMB', '894', 'Zâmbia');
INSERT INTO paises VALUES ('ZW', 'ZWE', '716', 'Zimbabwe');

Fonte: http://alisson.blog.br/banco-de-dados-com-todos-os-paises/

Compartilhar este post

Link para o post
Compartilhar em outros sites
Ir para a lista de tópicos PHP
×

Informação importante

Ao usar o fórum, você concorda com nossos Termos e condições.

  Aceito