Script com lista completa de países para quem precisar popular uma tabela rapidamente.

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', 'BLZ', '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 ('CU', '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 ('VC', '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');

Deixe uma resposta

Esse site utiliza o Akismet para reduzir spam. Aprenda como seus dados de comentários são processados.

Post Navigation