{"id":256,"date":"2013-08-30T14:20:59","date_gmt":"2013-08-30T17:20:59","guid":{"rendered":"http:\/\/gianfratti.com\/?p=256"},"modified":"2013-08-30T14:42:58","modified_gmt":"2013-08-30T17:42:58","slug":"script-com-lista-completa-de-paises","status":"publish","type":"post","link":"https:\/\/gianfratti.com\/index.php\/script-com-lista-completa-de-paises\/","title":{"rendered":"Script com lista completa de pa\u00edses."},"content":{"rendered":"<p>Script com lista completa de pa\u00edses para quem precisar popular uma tabela rapidamente.<!--more--><\/p>\n<pre>CREATE TABLE paises (\r\n\tiso CHAR(2) NOT NULL PRIMARY KEY,\r\n\tiso3 char(3) NOT NULL,\r\n\tnumcode SMALLINT,\r\n\tnome VARCHAR(255) NOT NULL\r\n);\r\nINSERT INTO paises VALUES ('AF', 'AFG', '004', 'Afeganist\u00e3o');\r\nINSERT INTO paises VALUES ('ZA', 'ZAF', '710', '\u00c1frica do Sul');\r\nINSERT INTO paises VALUES ('AX', 'ALA', '248', '\u00c5land, Ilhas');\r\nINSERT INTO paises VALUES ('AL', 'ALB', '008', 'Alb\u00e2nia');\r\nINSERT INTO paises VALUES ('DE', 'DEU', '276', 'Alemanha');\r\nINSERT INTO paises VALUES ('AD', 'AND', '020', 'Andorra');\r\nINSERT INTO paises VALUES ('AO', 'AGO', '024', 'Angola');\r\nINSERT INTO paises VALUES ('AI', 'AIA', '660', 'Anguilla');\r\nINSERT INTO paises VALUES ('AQ', 'ATA', '010', 'Ant\u00e1rctida');\r\nINSERT INTO paises VALUES ('AG', 'ATG', '028', 'Antigua e Barbuda');\r\nINSERT INTO paises VALUES ('AN', 'ANT', '530', 'Antilhas Holandesas');\r\nINSERT INTO paises VALUES ('SA', 'SAU', '682', 'Ar\u00e1bia Saudita');\r\nINSERT INTO paises VALUES ('DZ', 'DZA', '012', 'Arg\u00e9lia');\r\nINSERT INTO paises VALUES ('AR', 'ARG', '032', 'Argentina');\r\nINSERT INTO paises VALUES ('AM', 'ARM', '051', 'Arm\u00e9nia');\r\nINSERT INTO paises VALUES ('AW', 'ABW', '533', 'Aruba');\r\nINSERT INTO paises VALUES ('AU', 'AUS', '036', 'Austr\u00e1lia');\r\nINSERT INTO paises VALUES ('AT', 'AUT', '040', '\u00c1ustria');\r\nINSERT INTO paises VALUES ('AZ', 'AZE', '031', 'Azerbeij\u00e3o');\r\nINSERT INTO paises VALUES ('BS', 'BHS', '044', 'Bahamas');\r\nINSERT INTO paises VALUES ('BH', 'BHR', '048', 'Bahrain');\r\nINSERT INTO paises VALUES ('BD', 'BGD', '050', 'Bangladesh');\r\nINSERT INTO paises VALUES ('BB', 'BRB', '052', 'Barbados');\r\nINSERT INTO paises VALUES ('BE', 'BEL', '056', 'B\u00e9lgica');\r\nINSERT INTO paises VALUES ('BZ', 'BLZ', '084', 'Belize');\r\nINSERT INTO paises VALUES ('BJ', 'BEN', '204', 'Benin');\r\nINSERT INTO paises VALUES ('BM', 'BMU', '060', 'Bermuda');\r\nINSERT INTO paises VALUES ('BY', 'BLR', '112', 'Bielo-R\u00fassia');\r\nINSERT INTO paises VALUES ('BO', 'BOL', '068', 'Bol\u00edvia');\r\nINSERT INTO paises VALUES ('BA', 'BIH', '070', 'B\u00f3snia-Herzegovina');\r\nINSERT INTO paises VALUES ('BW', 'BWA', '072', 'Botswana');\r\nINSERT INTO paises VALUES ('BV', 'BVT', '074', 'Bouvet, Ilha');\r\nINSERT INTO paises VALUES ('BR', 'BRA', '076', 'Brasil');\r\nINSERT INTO paises VALUES ('BN', 'BRN', '096', 'Brunei');\r\nINSERT INTO paises VALUES ('BG', 'BGR', '100', 'Bulg\u00e1ria');\r\nINSERT INTO paises VALUES ('BF', 'BFA', '854', 'Burkina Faso');\r\nINSERT INTO paises VALUES ('BI', 'BDI', '108', 'Burundi');\r\nINSERT INTO paises VALUES ('BT', 'BTN', '064', 'But\u00e3o');\r\nINSERT INTO paises VALUES ('CV', 'CPV', '132', 'Cabo Verde');\r\nINSERT INTO paises VALUES ('KH', 'KHM', '116', 'Cambodja');\r\nINSERT INTO paises VALUES ('CM', 'CMR', '120', 'Camar\u00f5es');\r\nINSERT INTO paises VALUES ('CA', 'CAN', '124', 'Canad\u00e1');\r\nINSERT INTO paises VALUES ('KY', 'CYM', '136', 'Cayman, Ilhas');\r\nINSERT INTO paises VALUES ('KZ', 'KAZ', '398', 'Cazaquist\u00e3o');\r\nINSERT INTO paises VALUES ('CF', 'CAF', '140', 'Centro-africana, Rep\u00fablica');\r\nINSERT INTO paises VALUES ('TD', 'TCD', '148', 'Chade');\r\nINSERT INTO paises VALUES ('CZ', 'CZE', '203', 'Checa, Rep\u00fablica');\r\nINSERT INTO paises VALUES ('CL', 'CHL', '152', 'Chile');\r\nINSERT INTO paises VALUES ('CN', 'CHN', '156', 'China');\r\nINSERT INTO paises VALUES ('CY', 'CYP', '196', 'Chipre');\r\nINSERT INTO paises VALUES ('CX', 'CXR', '162', 'Christmas, Ilha');\r\nINSERT INTO paises VALUES ('CC', 'CCK', '166', 'Cocos, Ilhas');\r\nINSERT INTO paises VALUES ('CO', 'COL', '170', 'Col\u00f4mbia');\r\nINSERT INTO paises VALUES ('KM', 'COM', '174', 'Comores');\r\nINSERT INTO paises VALUES ('CG', 'COG', '178', 'Congo, Rep\u00fablica do');\r\nINSERT INTO paises VALUES ('CD', 'COD', '180', 'Congo, Rep\u00fablica Democr\u00e1tica do (antigo Zaire)');\r\nINSERT INTO paises VALUES ('CK', 'COK', '184', 'Cook, Ilhas');\r\nINSERT INTO paises VALUES ('KR', 'KOR', '410', 'Coreia do Sul');\r\nINSERT INTO paises VALUES ('KP', 'PRK', '408', 'Coreia, Rep\u00fablica Democr\u00e1tica da (Coreia do Norte)');\r\nINSERT INTO paises VALUES ('CI', 'CIV', '384', 'Costa do Marfim');\r\nINSERT INTO paises VALUES ('CR', 'CRI', '188', 'Costa Rica');\r\nINSERT INTO paises VALUES ('HR', 'HRV', '191', 'Cro\u00e1cia');\r\nINSERT INTO paises VALUES ('CU', 'CUB', '192', 'Cuba');\r\nINSERT INTO paises VALUES ('DK', 'DNK', '208', 'Dinamarca');\r\nINSERT INTO paises VALUES ('DJ', 'DJI', '262', 'Djibouti');\r\nINSERT INTO paises VALUES ('DM', 'DMA', '212', 'Dominica');\r\nINSERT INTO paises VALUES ('DO', 'DOM', '214', 'Dominicana, Rep\u00fablica');\r\nINSERT INTO paises VALUES ('EG', 'EGY', '818', 'Egipto');\r\nINSERT INTO paises VALUES ('SV', 'SLV', '222', 'El Salvador');\r\nINSERT INTO paises VALUES ('AE', 'ARE', '784', 'Emiratos \u00c1rabes Unidos');\r\nINSERT INTO paises VALUES ('EC', 'ECU', '218', 'Equador');\r\nINSERT INTO paises VALUES ('ER', 'ERI', '232', 'Eritreia');\r\nINSERT INTO paises VALUES ('SK', 'SVK', '703', 'Eslov\u00e1quia');\r\nINSERT INTO paises VALUES ('SI', 'SVN', '705', 'Eslov\u00e9nia');\r\nINSERT INTO paises VALUES ('ES', 'ESP', '724', 'Espanha');\r\nINSERT INTO paises VALUES ('US', 'USA', '840', 'Estados Unidos da Am\u00e9rica');\r\nINSERT INTO paises VALUES ('EE', 'EST', '233', 'Est\u00f3nia');\r\nINSERT INTO paises VALUES ('ET', 'ETH', '231', 'Eti\u00f3pia');\r\nINSERT INTO paises VALUES ('FO', 'FRO', '234', 'Faroe, Ilhas');\r\nINSERT INTO paises VALUES ('FJ', 'FJI', '242', 'Fiji');\r\nINSERT INTO paises VALUES ('PH', 'PHL', '608', 'Filipinas');\r\nINSERT INTO paises VALUES ('FI', 'FIN', '246', 'Finl\u00e2ndia');\r\nINSERT INTO paises VALUES ('FR', 'FRA', '250', 'Fran\u00e7a');\r\nINSERT INTO paises VALUES ('GA', 'GAB', '266', 'Gab\u00e3o');\r\nINSERT INTO paises VALUES ('GM', 'GMB', '270', 'G\u00e2mbia');\r\nINSERT INTO paises VALUES ('GH', 'GHA', '288', 'Gana');\r\nINSERT INTO paises VALUES ('GE', 'GEO', '268', 'Ge\u00f3rgia');\r\nINSERT INTO paises VALUES ('GS', 'SGS', '239', 'Ge\u00f3rgia do Sul e Sandwich do Sul, Ilhas');\r\nINSERT INTO paises VALUES ('GI', 'GIB', '292', 'Gibraltar');\r\nINSERT INTO paises VALUES ('GR', 'GRC', '300', 'Gr\u00e9cia');\r\nINSERT INTO paises VALUES ('GD', 'GRD', '308', 'Grenada');\r\nINSERT INTO paises VALUES ('GL', 'GRL', '304', 'Gronel\u00e2ndia');\r\nINSERT INTO paises VALUES ('GP', 'GLP', '312', 'Guadeloupe');\r\nINSERT INTO paises VALUES ('GU', 'GUM', '316', 'Guam');\r\nINSERT INTO paises VALUES ('GT', 'GTM', '320', 'Guatemala');\r\nINSERT INTO paises VALUES ('GG', 'GGY', '831', 'Guernsey');\r\nINSERT INTO paises VALUES ('GY', 'GUY', '328', 'Guiana');\r\nINSERT INTO paises VALUES ('GF', 'GUF', '254', 'Guiana Francesa');\r\nINSERT INTO paises VALUES ('GW', 'GNB', '624', 'Guin\u00e9-Bissau');\r\nINSERT INTO paises VALUES ('GN', 'GIN', '324', 'Guin\u00e9-Conacri');\r\nINSERT INTO paises VALUES ('GQ', 'GNQ', '226', 'Guin\u00e9 Equatorial');\r\nINSERT INTO paises VALUES ('HT', 'HTI', '332', 'Haiti');\r\nINSERT INTO paises VALUES ('HM', 'HMD', '334', 'Heard e Ilhas McDonald, Ilha');\r\nINSERT INTO paises VALUES ('HN', 'HND', '340', 'Honduras');\r\nINSERT INTO paises VALUES ('HK', 'HKG', '344', 'Hong Kong');\r\nINSERT INTO paises VALUES ('HU', 'HUN', '348', 'Hungria');\r\nINSERT INTO paises VALUES ('YE', 'YEM', '887', 'I\u00e9men');\r\nINSERT INTO paises VALUES ('IN', 'IND', '356', '\u00cdndia');\r\nINSERT INTO paises VALUES ('ID', 'IDN', '360', 'Indon\u00e9sia');\r\nINSERT INTO paises VALUES ('IQ', 'IRQ', '368', 'Iraque');\r\nINSERT INTO paises VALUES ('IR', 'IRN', '364', 'Ir\u00e3o');\r\nINSERT INTO paises VALUES ('IE', 'IRL', '372', 'Irlanda');\r\nINSERT INTO paises VALUES ('IS', 'ISL', '352', 'Isl\u00e2ndia');\r\nINSERT INTO paises VALUES ('IL', 'ISR', '376', 'Israel');\r\nINSERT INTO paises VALUES ('IT', 'ITA', '380', 'It\u00e1lia');\r\nINSERT INTO paises VALUES ('JM', 'JAM', '388', 'Jamaica');\r\nINSERT INTO paises VALUES ('JP', 'JPN', '392', 'Jap\u00e3o');\r\nINSERT INTO paises VALUES ('JE', 'JEY', '832', 'Jersey');\r\nINSERT INTO paises VALUES ('JO', 'JOR', '400', 'Jord\u00e2nia');\r\nINSERT INTO paises VALUES ('KI', 'KIR', '296', 'Kiribati');\r\nINSERT INTO paises VALUES ('KW', 'KWT', '414', 'Kuwait');\r\nINSERT INTO paises VALUES ('LA', 'LAO', '418', 'Laos');\r\nINSERT INTO paises VALUES ('LS', 'LSO', '426', 'Lesoto');\r\nINSERT INTO paises VALUES ('LV', 'LVA', '428', 'Let\u00f3nia');\r\nINSERT INTO paises VALUES ('LB', 'LBN', '422', 'L\u00edbano');\r\nINSERT INTO paises VALUES ('LR', 'LBR', '430', 'Lib\u00e9ria');\r\nINSERT INTO paises VALUES ('LY', 'LBY', '434', 'L\u00edbia');\r\nINSERT INTO paises VALUES ('LI', 'LIE', '438', 'Liechtenstein');\r\nINSERT INTO paises VALUES ('LT', 'LTU', '440', 'Litu\u00e2nia');\r\nINSERT INTO paises VALUES ('LU', 'LUX', '442', 'Luxemburgo');\r\nINSERT INTO paises VALUES ('MO', 'MAC', '446', 'Macau');\r\nINSERT INTO paises VALUES ('MK', 'MKD', '807', 'Maced\u00f3nia, Rep\u00fablica da');\r\nINSERT INTO paises VALUES ('MG', 'MDG', '450', 'Madag\u00e1scar');\r\nINSERT INTO paises VALUES ('MY', 'MYS', '458', 'Mal\u00e1sia');\r\nINSERT INTO paises VALUES ('MW', 'MWI', '454', 'Malawi');\r\nINSERT INTO paises VALUES ('MV', 'MDV', '462', 'Maldivas');\r\nINSERT INTO paises VALUES ('ML', 'MLI', '466', 'Mali');\r\nINSERT INTO paises VALUES ('MT', 'MLT', '470', 'Malta');\r\nINSERT INTO paises VALUES ('FK', 'FLK', '238', 'Malvinas, Ilhas (Falkland)');\r\nINSERT INTO paises VALUES ('IM', 'IMN', '833', 'Man, Ilha de');\r\nINSERT INTO paises VALUES ('MP', 'MNP', '580', 'Marianas Setentrionais');\r\nINSERT INTO paises VALUES ('MA', 'MAR', '504', 'Marrocos');\r\nINSERT INTO paises VALUES ('MH', 'MHL', '584', 'Marshall, Ilhas');\r\nINSERT INTO paises VALUES ('MQ', 'MTQ', '474', 'Martinica');\r\nINSERT INTO paises VALUES ('MU', 'MUS', '480', 'Maur\u00edcia');\r\nINSERT INTO paises VALUES ('MR', 'MRT', '478', 'Maurit\u00e2nia');\r\nINSERT INTO paises VALUES ('YT', 'MYT', '175', 'Mayotte');\r\nINSERT INTO paises VALUES ('UM', 'UMI', '581', 'Menores Distantes dos Estados Unidos, Ilhas');\r\nINSERT INTO paises VALUES ('MX', 'MEX', '484', 'M\u00e9xico');\r\nINSERT INTO paises VALUES ('MM', 'MMR', '104', 'Myanmar (antiga Birm\u00e2nia)');\r\nINSERT INTO paises VALUES ('FM', 'FSM', '583', 'Micron\u00e9sia, Estados Federados da');\r\nINSERT INTO paises VALUES ('MZ', 'MOZ', '508', 'Mo\u00e7ambique');\r\nINSERT INTO paises VALUES ('MD', 'MDA', '498', 'Mold\u00e1via');\r\nINSERT INTO paises VALUES ('MC', 'MCO', '492', 'M\u00f3naco');\r\nINSERT INTO paises VALUES ('MN', 'MNG', '496', 'Mong\u00f3lia');\r\nINSERT INTO paises VALUES ('ME', 'MNE', '499', 'Montenegro');\r\nINSERT INTO paises VALUES ('MS', 'MSR', '500', 'Montserrat');\r\nINSERT INTO paises VALUES ('NA', 'NAM', '516', 'Nam\u00edbia');\r\nINSERT INTO paises VALUES ('NR', 'NRU', '520', 'Nauru');\r\nINSERT INTO paises VALUES ('NP', 'NPL', '524', 'Nepal');\r\nINSERT INTO paises VALUES ('NI', 'NIC', '558', 'Nicar\u00e1gua');\r\nINSERT INTO paises VALUES ('NE', 'NER', '562', 'N\u00edger');\r\nINSERT INTO paises VALUES ('NG', 'NGA', '566', 'Nig\u00e9ria');\r\nINSERT INTO paises VALUES ('NU', 'NIU', '570', 'Niue');\r\nINSERT INTO paises VALUES ('NF', 'NFK', '574', 'Norfolk, Ilha');\r\nINSERT INTO paises VALUES ('NO', 'NOR', '578', 'Noruega');\r\nINSERT INTO paises VALUES ('NC', 'NCL', '540', 'Nova Caled\u00f3nia');\r\nINSERT INTO paises VALUES ('NZ', 'NZL', '554', 'Nova Zel\u00e2ndia (Aotearoa)');\r\nINSERT INTO paises VALUES ('OM', 'OMN', '512', 'Oman');\r\nINSERT INTO paises VALUES ('NL', 'NLD', '528', 'Pa\u00edses Baixos (Holanda)');\r\nINSERT INTO paises VALUES ('PW', 'PLW', '585', 'Palau');\r\nINSERT INTO paises VALUES ('PS', 'PSE', '275', 'Palestina');\r\nINSERT INTO paises VALUES ('PA', 'PAN', '591', 'Panam\u00e1');\r\nINSERT INTO paises VALUES ('PG', 'PNG', '598', 'Papua-Nova Guin\u00e9');\r\nINSERT INTO paises VALUES ('PK', 'PAK', '586', 'Paquist\u00e3o');\r\nINSERT INTO paises VALUES ('PY', 'PRY', '600', 'Paraguai');\r\nINSERT INTO paises VALUES ('PE', 'PER', '604', 'Peru');\r\nINSERT INTO paises VALUES ('PN', 'PCN', '612', 'Pitcairn');\r\nINSERT INTO paises VALUES ('PF', 'PYF', '258', 'Polin\u00e9sia Francesa');\r\nINSERT INTO paises VALUES ('PL', 'POL', '616', 'Pol\u00f3nia');\r\nINSERT INTO paises VALUES ('PR', 'PRI', '630', 'Porto Rico');\r\nINSERT INTO paises VALUES ('PT', 'PRT', '620', 'Portugal');\r\nINSERT INTO paises VALUES ('QA', 'QAT', '634', 'Qatar');\r\nINSERT INTO paises VALUES ('KE', 'KEN', '404', 'Qu\u00e9nia');\r\nINSERT INTO paises VALUES ('KG', 'KGZ', '417', 'Quirguist\u00e3o');\r\nINSERT INTO paises VALUES ('GB', 'GBR', '826', 'Reino Unido da Gr\u00e3-Bretanha e Irlanda do Norte');\r\nINSERT INTO paises VALUES ('RE', 'REU', '638', 'Reuni\u00e3o');\r\nINSERT INTO paises VALUES ('RO', 'ROU', '642', 'Rom\u00e9nia');\r\nINSERT INTO paises VALUES ('RW', 'RWA', '646', 'Ruanda');\r\nINSERT INTO paises VALUES ('RU', 'RUS', '643', 'R\u00fassia');\r\nINSERT INTO paises VALUES ('EH', 'ESH', '732', 'Saara Ocidental');\r\nINSERT INTO paises VALUES ('AS', 'ASM', '016', 'Samoa Americana');\r\nINSERT INTO paises VALUES ('WS', 'WSM', '882', 'Samoa (Samoa Ocidental)');\r\nINSERT INTO paises VALUES ('PM', 'SPM', '666', 'Saint Pierre et Miquelon');\r\nINSERT INTO paises VALUES ('SB', 'SLB', '090', 'Salom\u00e3o, Ilhas');\r\nINSERT INTO paises VALUES ('KN', 'KNA', '659', 'S\u00e3o Crist\u00f3v\u00e3o e N\u00e9vis (Saint Kitts e Nevis)');\r\nINSERT INTO paises VALUES ('SM', 'SMR', '674', 'San Marino');\r\nINSERT INTO paises VALUES ('ST', 'STP', '678', 'S\u00e3o Tom\u00e9 e Pr\u00edncipe');\r\nINSERT INTO paises VALUES ('VC', 'VCT', '670', 'S\u00e3o Vicente e Granadinas');\r\nINSERT INTO paises VALUES ('SH', 'SHN', '654', 'Santa Helena');\r\nINSERT INTO paises VALUES ('LC', 'LCA', '662', 'Santa L\u00facia');\r\nINSERT INTO paises VALUES ('SN', 'SEN', '686', 'Senegal');\r\nINSERT INTO paises VALUES ('SL', 'SLE', '694', 'Serra Leoa');\r\nINSERT INTO paises VALUES ('RS', 'SRB', '688', 'S\u00e9rvia');\r\nINSERT INTO paises VALUES ('SC', 'SYC', '690', 'Seychelles');\r\nINSERT INTO paises VALUES ('SG', 'SGP', '702', 'Singapura');\r\nINSERT INTO paises VALUES ('SY', 'SYR', '760', 'S\u00edria');\r\nINSERT INTO paises VALUES ('SO', 'SOM', '706', 'Som\u00e1lia');\r\nINSERT INTO paises VALUES ('LK', 'LKA', '144', 'Sri Lanka');\r\nINSERT INTO paises VALUES ('SZ', 'SWZ', '748', 'Suazil\u00e2ndia');\r\nINSERT INTO paises VALUES ('SD', 'SDN', '736', 'Sud\u00e3o');\r\nINSERT INTO paises VALUES ('SE', 'SWE', '752', 'Su\u00e9cia');\r\nINSERT INTO paises VALUES ('CH', 'CHE', '756', 'Su\u00ed\u00e7a');\r\nINSERT INTO paises VALUES ('SR', 'SUR', '740', 'Suriname');\r\nINSERT INTO paises VALUES ('SJ', 'SJM', '744', 'Svalbard e Jan Mayen');\r\nINSERT INTO paises VALUES ('TH', 'THA', '764', 'Tail\u00e2ndia');\r\nINSERT INTO paises VALUES ('TW', 'TWN', '158', 'Taiwan');\r\nINSERT INTO paises VALUES ('TJ', 'TJK', '762', 'Tajiquist\u00e3o');\r\nINSERT INTO paises VALUES ('TZ', 'TZA', '834', 'Tanz\u00e2nia');\r\nINSERT INTO paises VALUES ('TF', 'ATF', '260', 'Terras Austrais e Ant\u00e1rticas Francesas (TAAF)');\r\nINSERT INTO paises VALUES ('IO', 'IOT', '086', 'Territ\u00f3rio Brit\u00e2nico do Oceano \u00cdndico');\r\nINSERT INTO paises VALUES ('TL', 'TLS', '626', 'Timor-Leste');\r\nINSERT INTO paises VALUES ('TG', 'TGO', '768', 'Togo');\r\nINSERT INTO paises VALUES ('TK', 'TKL', '772', 'Toquelau');\r\nINSERT INTO paises VALUES ('TO', 'TON', '776', 'Tonga');\r\nINSERT INTO paises VALUES ('TT', 'TTO', '780', 'Trindade e Tobago');\r\nINSERT INTO paises VALUES ('TN', 'TUN', '788', 'Tun\u00edsia');\r\nINSERT INTO paises VALUES ('TC', 'TCA', '796', 'Turks e Caicos');\r\nINSERT INTO paises VALUES ('TM', 'TKM', '795', 'Turquemenist\u00e3o');\r\nINSERT INTO paises VALUES ('TR', 'TUR', '792', 'Turquia');\r\nINSERT INTO paises VALUES ('TV', 'TUV', '798', 'Tuvalu');\r\nINSERT INTO paises VALUES ('UA', 'UKR', '804', 'Ucr\u00e2nia');\r\nINSERT INTO paises VALUES ('UG', 'UGA', '800', 'Uganda');\r\nINSERT INTO paises VALUES ('UY', 'URY', '858', 'Uruguai');\r\nINSERT INTO paises VALUES ('UZ', 'UZB', '860', 'Usbequist\u00e3o');\r\nINSERT INTO paises VALUES ('VU', 'VUT', '548', 'Vanuatu');\r\nINSERT INTO paises VALUES ('VA', 'VAT', '336', 'Vaticano');\r\nINSERT INTO paises VALUES ('VE', 'VEN', '862', 'Venezuela');\r\nINSERT INTO paises VALUES ('VN', 'VNM', '704', 'Vietname');\r\nINSERT INTO paises VALUES ('VI', 'VIR', '850', 'Virgens Americanas, Ilhas');\r\nINSERT INTO paises VALUES ('VG', 'VGB', '092', 'Virgens Brit\u00e2nicas, Ilhas');\r\nINSERT INTO paises VALUES ('WF', 'WLF', '876', 'Wallis e Futuna');\r\nINSERT INTO paises VALUES ('ZM', 'ZMB', '894', 'Z\u00e2mbia');\r\nINSERT INTO paises VALUES ('ZW', 'ZWE', '716', 'Zimbabwe');<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Script com lista completa de pa\u00edses para quem precisar popular uma tabela rapidamente.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[19,18],"tags":[47],"class_list":["post-256","post","type-post","status-publish","format-standard","hentry","category-mysql","category-sql-server","tag-scriptsqlpaises"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/gianfratti.com\/index.php\/wp-json\/wp\/v2\/posts\/256","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gianfratti.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gianfratti.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gianfratti.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gianfratti.com\/index.php\/wp-json\/wp\/v2\/comments?post=256"}],"version-history":[{"count":2,"href":"https:\/\/gianfratti.com\/index.php\/wp-json\/wp\/v2\/posts\/256\/revisions"}],"predecessor-version":[{"id":258,"href":"https:\/\/gianfratti.com\/index.php\/wp-json\/wp\/v2\/posts\/256\/revisions\/258"}],"wp:attachment":[{"href":"https:\/\/gianfratti.com\/index.php\/wp-json\/wp\/v2\/media?parent=256"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gianfratti.com\/index.php\/wp-json\/wp\/v2\/categories?post=256"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gianfratti.com\/index.php\/wp-json\/wp\/v2\/tags?post=256"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}