<br />
<b>Notice</b>:  Function _load_textdomain_just_in_time was called <strong>incorrectly</strong>. Translation loading for the <code>breadcrumb-navxt</code> domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the <code>init</code> action or later. Please see <a href="https://developer.wordpress.org/advanced-administration/debug/debug-wordpress/">Debugging in WordPress</a> for more information. (This message was added in version 6.7.0.) in <b>/home/devtools/public_html/blog/wp-includes/functions.php</b> on line <b>6131</b><br />
{"id":1295,"date":"2021-08-27T13:12:35","date_gmt":"2021-08-27T16:12:35","guid":{"rendered":"https:\/\/devtools.com.br\/blog\/?p=1295"},"modified":"2022-08-01T19:52:08","modified_gmt":"2022-08-01T22:52:08","slug":"tabela-de-paises","status":"publish","type":"post","link":"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/","title":{"rendered":"Tabela de Pa\u00edses"},"content":{"rendered":"\n<p>Neste post trazemos a lista de pa\u00edses, com respetivo nome original, o nome em portugu\u00eas  daquele pa\u00eds, a sigla e o c\u00f3digo internacional.<\/p>\n\n\n\n<p>A estrutura da tabela \u00e9:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>CREATE TABLE <span style=\"background-color: inherit; font-size: inherit; color: inherit;\">pais<\/span> (\n<code>id<\/code> int(11) NOT NULL,\n<code>nome<\/code> varchar(60) DEFAULT NULL,\n<code>nome_pt<\/code> varchar(60) DEFAULT NULL,\n<code>sigla<\/code> varchar(2) DEFAULT NULL,\n<code>bacen<\/code> int(5) DEFAULT NULL\n) ENGINE=INNODB DEFAULT CHARSET=utf8 COMMENT='Pa\u00edses e Na\u00e7\u00f5es';<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<div id=\"denakop-ad-horizontal-1\">\n   <script type=\"text\/javascript\">\n     denakop.cmd.push(function () {\n        denakop.displayAd({\n           divId: \"denakop-ad-horizontal-1\",\n           name: \"horizontal\",\n           refresh: 30,\n        });\n     });\n   <\/script>\n<\/div>\n\n\n\n<p>Para inser\u00e7\u00e3o dos registros, ou seja, todos os pa\u00edses, utilize o seguinte SQL:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>INSERT INTO `pais` (`id`, `nome`, `nome_pt`, `sigla`, `bacen`) VALUES\n(1, 'Brazil', 'Brasil', 'BR', 1058),\n(2, 'Afghanistan', 'Afeganist\u00e3o', 'AF', 132),\n(3, 'Albania', 'Alb\u00e2nia, Republica da', 'AL', 175),\n(4, 'Algeria', 'Arg\u00e9lia', 'DZ', 590),\n(5, 'American Samoa', 'Samoa Americana', 'AS', 6912),\n(6, 'Andorra', 'Andorra', 'AD', 370),\n(7, 'Angola', 'Angola', 'AO', 400),\n(8, 'Anguilla', 'Anguilla', 'AI', 418),\n(9, 'Antarctica', 'Ant\u00e1rtida', 'AQ', 3596),\n(10, 'Antigua and Barbuda', 'Antigua e Barbuda', 'AG', 434),\n(11, 'Argentina', 'Argentina', 'AR', 639),\n(12, 'Armenia', 'Arm\u00eania, Republica da', 'AM', 647),\n(13, 'Aruba', 'Aruba', 'AW', 655),\n(14, 'Australia', 'Austr\u00e1lia', 'AU', 698),\n(15, 'Austria', '\u00c1ustria', 'AT', 728),\n(16, 'Azerbaijan', 'Azerbaij\u00e3o, Republica do', 'AZ', 736),\n(17, 'Bahamas', 'Bahamas, Ilhas', 'BS', 779),\n(18, 'Bahrain', 'Bahrein, Ilhas', 'BH', 809),\n(19, 'Bangladesh', 'Bangladesh', 'BD', 817),\n(20, 'Barbados', 'Barbados', 'BB', 833),\n(21, 'Belarus', 'Belarus, Republica da', 'BY', 850),\n(22, 'Belgium', 'B\u00e9lgica', 'BE', 876),\n(23, 'Belize', 'Belize', 'BZ', 884),\n(24, 'Benin', 'Benin', 'BJ', 2291),\n(25, 'Bermuda', 'Bermudas', 'BM', 906),\n(26, 'Bhutan', 'But\u00e3o', 'BT', 1198),\n(27, 'Bolivia', 'Bol\u00edvia', 'BO', 973),\n(28, 'Bosnia and Herzegowina', 'B\u00f3snia-herzegovina (Republica da)', 'BA', 981),\n(29, 'Botswana', 'Botsuana', 'BW', 1015),\n(30, 'Bouvet Island', 'Bouvet, Ilha', 'BV', 1023),\n(31, 'British Indian Ocean Territory', 'Territ\u00f3rio Brit\u00e2nico do Oceano Indico', 'IO', 7820),\n(32, 'Brunei Darussalam', 'Brunei', 'BN', 1082),\n(33, 'Bulgaria', 'Bulg\u00e1ria, Republica da', 'BG', 1112),\n(34, 'Burkina Faso', 'Burkina Faso', 'BF', 310),\n(35, 'Burundi', 'Burundi', 'BI', 1155),\n(36, 'Cambodia', 'Camboja', 'KH', 1414),\n(37, 'Cameroon', 'Camar\u00f5es', 'CM', 1457),\n(38, 'Canada', 'Canada', 'CA', 1490),\n(39, 'Cape Verde', 'Cabo Verde, Republica de', 'CV', 1279),\n(40, 'Cayman Islands', 'Cayman, Ilhas', 'KY', 1376),\n(41, 'Central African Republic', 'Republica Centro-Africana', 'CF', 6408),\n(42, 'Chad', 'Chade', 'TD', 7889),\n(43, 'Chile', 'Chile', 'CL', 1589),\n(44, 'China', 'China, Republica Popular', 'CN', 1600),\n(45, 'Christmas Island', 'Christmas, Ilha (Navidad)', 'CX', 5118),\n(46, 'Cocos (Keeling) Islands', 'Cocos (Keeling), Ilhas', 'CC', 1651),\n(47, 'Colombia', 'Col\u00f4mbia', 'CO', 1694),\n(48, 'Comoros', 'Comores, Ilhas', 'KM', 1732),\n(49, 'Congo', 'Congo', 'CG', 1775),\n(50, 'Congo, the Democratic Republic of the', 'Congo, Republica Democr\u00e1tica do', 'CD', 8885),\n(51, 'Cook Islands', 'Cook, Ilhas', 'CK', 1830),\n(52, 'Costa Rica', 'Costa Rica', 'CR', 1961),\n(53, 'Cote dIvoire', 'Costa do Marfim', 'CI', 1937),\n(54, 'Croatia (Hrvatska)', 'Cro\u00e1cia (Republica da)', 'HR', 1953),\n(55, 'Cuba', 'Cuba', 'CU', 1996),\n(56, 'Cyprus', 'Chipre', 'CY', 1635),\n(57, 'Czech Republic', 'Tcheca, Republica', 'CZ', 7919),\n(58, 'Denmark', 'Dinamarca', 'DK', 2321),\n(59, 'Djibouti', 'Djibuti', 'DJ', 7838),\n(60, 'Dominica', 'Dominica, Ilha', 'DM', 2356),\n(61, 'Dominican Republic', 'Republica Dominicana', 'DO', 6475),\n(62, 'East Timor', 'Timor Leste', 'TL', 7951),\n(63, 'Ecuador', 'Equador', 'EC', 2399),\n(64, 'Egypt', 'Egito', 'EG', 2402),\n(65, 'El Salvador', 'El Salvador', 'SV', 6874),\n(66, 'Equatorial Guinea', 'Guine-Equatorial', 'GQ', 3310),\n(67, 'Eritrea', 'Eritreia', 'ER', 2437),\n(68, 'Estonia', 'Est\u00f4nia, Republica da', 'EE', 2518),\n(69, 'Ethiopia', 'Eti\u00f3pia', 'ET', 2534),\n(70, 'Falkland Islands (Malvinas)', 'Falkland (Ilhas Malvinas)', 'FK', 2550),\n(71, 'Faroe Islands', 'Feroe, Ilhas', 'FO', 2593),\n(72, 'Fiji', 'Fiji', 'FJ', 8702),\n(73, 'Finland', 'Finl\u00e2ndia', 'FI', 2712),\n(74, 'France', 'Franca', 'FR', 2755),\n(76, 'French Guiana', 'Guiana francesa', 'GF', 3255),\n(77, 'French Polynesia', 'Polin\u00e9sia Francesa', 'PF', 5991),\n(78, 'French Southern Territories', 'Terras Austrais e Ant\u00e1rticas Francesas', 'TF', 3607),\n(79, 'Gabon', 'Gab\u00e3o', 'GA', 2810),\n(80, 'Gambia', 'Gambia', 'GM', 2852),\n(81, 'Georgia', 'Georgia, Republica da', 'GE', 2917),\n(82, 'Germany', 'Alemanha', 'DE', 230),\n(83, 'Ghana', 'Gana', 'GH', 2895),\n(84, 'Gibraltar', 'Gibraltar', 'GI', 2933),\n(85, 'Greece', 'Gr\u00e9cia', 'GR', 3018),\n(86, 'Greenland', 'Groenl\u00e2ndia', 'GL', 3050),\n(87, 'Grenada', 'Granada', 'GD', 2976),\n(88, 'Guadeloupe', 'Guadalupe', 'GP', 3093),\n(89, 'Guam', 'Guam', 'GU', 3131),\n(90, 'Guatemala', 'Guatemala', 'GT', 3174),\n(91, 'Guinea', 'Guine', 'GN', 3298),\n(92, 'Guinea-Bissau', 'Guine-Bissau', 'GW', 3344),\n(93, 'Guyana', 'Guiana', 'GY', 3379),\n(94, 'Haiti', 'Haiti', 'HT', 3417),\n(95, 'Heard and Mc Donald Islands', 'Ilha Heard e Ilhas McDonald', 'HM', 3603),\n(96, 'Holy See (Vatican City State)', 'Vaticano, Estado da Cidade do', 'VA', 8486),\n(97, 'Honduras', 'Honduras', 'HN', 3450),\n(98, 'Hong Kong', 'Hong Kong', 'HK', 3514),\n(99, 'Hungary', 'Hungria, Republica da', 'HU', 3557),\n(100, 'Iceland', 'Isl\u00e2ndia', 'IS', 3794),\n(101, 'India', '\u00cdndia', 'IN', 3611),\n(102, 'Indonesia', 'Indon\u00e9sia', 'ID', 3654),\n(103, 'Iran (Islamic Republic of)', 'Ira, Republica Isl\u00e2mica do', 'IR', 3727),\n(104, 'Iraq', 'Iraque', 'IQ', 3697),\n(105, 'Ireland', 'Irlanda', 'IE', 3751),\n(106, 'Israel', 'Israel', 'IL', 3832),\n(107, 'Italy', 'It\u00e1lia', 'IT', 3867),\n(108, 'Jamaica', 'Jamaica', 'JM', 3913),\n(109, 'Japan', 'Jap\u00e3o', 'JP', 3999),\n(110, 'Jordan', 'Jord\u00e2nia', 'JO', 4030),\n(111, 'Kazakhstan', 'Cazaquist\u00e3o, Republica do', 'KZ', 1538),\n(112, 'Kenya', 'Qu\u00eania', 'KE', 6238),\n(113, 'Kiribati', 'Kiribati', 'KI', 4111),\n(114, 'Korea, Democratic People`s Republic of', 'Coreia, Republica Popular Democr\u00e1tica da', 'KP', 1872),\n(115, 'Korea, Republic of', 'Coreia, Republica da', 'KR', 1902),\n(116, 'Kuwait', 'Kuwait', 'KW', 1988),\n(117, 'Kyrgyzstan', 'Quirguiz, Republica', 'KG', 6254),\n(118, 'Lao People`s Democratic Republic', 'Laos, Republica Popular Democr\u00e1tica do', 'LA', 4200),\n(119, 'Latvia', 'Let\u00f4nia, Republica da', 'LV', 4278),\n(120, 'Lebanon', 'L\u00edbano', 'LB', 4316),\n(121, 'Lesotho', 'Lesoto', 'LS', 4260),\n(122, 'Liberia', 'Lib\u00e9ria', 'LR', 4340),\n(123, 'Libyan Arab Jamahiriya', 'L\u00edbia', 'LY', 4383),\n(124, 'Liechtenstein', 'Liechtenstein', 'LI', 4405),\n(125, 'Lithuania', 'Litu\u00e2nia, Republica da', 'LT', 4421),\n(126, 'Luxembourg', 'Luxemburgo', 'LU', 4456),\n(127, 'Macau', 'Macau', 'MO', 4472),\n(128, 'North Macedonia', 'Maced\u00f4nia do Norte', 'MK', 4499),\n(129, 'Madagascar', 'Madagascar', 'MG', 4502),\n(130, 'Malawi', 'Malavi', 'MW', 4588),\n(131, 'Malaysia', 'Mal\u00e1sia', 'MY', 4553),\n(132, 'Maldives', 'Maldivas', 'MV', 4618),\n(133, 'Mali', 'Mali', 'ML', 4642),\n(134, 'Malta', 'Malta', 'MT', 4677),\n(135, 'Marshall Islands', 'Marshall, Ilhas', 'MH', 4766),\n(136, 'Martinique', 'Martinica', 'MQ', 4774),\n(137, 'Mauritania', 'Maurit\u00e2nia', 'MR', 4880),\n(138, 'Mauritius', 'Mauricio', 'MU', 4855),\n(139, 'Mayotte', 'Mayotte (Ilhas Francesas)', 'YT', 4885),\n(140, 'Mexico', 'M\u00e9xico', 'MX', 4936),\n(141, 'Micronesia, Federated States of', 'Micronesia', 'FM', 4995),\n(142, 'Moldova, Republic of', 'Mold\u00e1via, Republica da', 'MD', 4944),\n(143, 'Monaco', 'M\u00f4naco', 'MC', 4952),\n(144, 'Mongolia', 'Mong\u00f3lia', 'MN', 4979),\n(145, 'Montserrat', 'Montserrat, Ilhas', 'MS', 5010),\n(146, 'Morocco', 'Marrocos', 'MA', 4740),\n(147, 'Mozambique', 'Mo\u00e7ambique', 'MZ', 5053),\n(148, 'Myanmar', 'Mianmar (Birm\u00e2nia)', 'MM', 930),\n(149, 'Namibia', 'Nam\u00edbia', 'NA', 5070),\n(150, 'Nauru', 'Nauru', 'NR', 5088),\n(151, 'Nepal', 'Nepal', 'NP', 5177),\n(152, 'Netherlands', 'Pa\u00edses Baixos (Holanda)', 'NL', 5738),\n(154, 'New Caledonia', 'Nova Caledonia', 'NC', 5428),\n(155, 'New Zealand', 'Nova Zel\u00e2ndia', 'NZ', 5487),\n(156, 'Nicaragua', 'Nicar\u00e1gua', 'NI', 5215),\n(157, 'Niger', 'N\u00edger', 'NE', 5258),\n(158, 'Nigeria', 'Nig\u00e9ria', 'NG', 5282),\n(159, 'Niue', 'Niue, Ilha', 'NU', 5312),\n(160, 'Norfolk Island', 'Norfolk, Ilha', 'NF', 5355),\n(161, 'Northern Mariana Islands', 'Marianas do Norte', 'MP', 4723),\n(162, 'Norway', 'Noruega', 'NO', 5380),\n(163, 'Oman', 'Oma', 'OM', 5568),\n(164, 'Pakistan', 'Paquist\u00e3o', 'PK', 5762),\n(165, 'Palau', 'Palau', 'PW', 5754),\n(166, 'Panama', 'Panam\u00e1', 'PA', 5800),\n(167, 'Papua New Guinea', 'Papua Nova Guine', 'PG', 5452),\n(168, 'Paraguay', 'Paraguai', 'PY', 5860),\n(169, 'Peru', 'Peru', 'PE', 5894),\n(170, 'Philippines', 'Filipinas', 'PH', 2674),\n(171, 'Pitcairn', 'Pitcairn, Ilha', 'PN', 5932),\n(172, 'Poland', 'Pol\u00f4nia, Republica da', 'PL', 6033),\n(173, 'Portugal', 'Portugal', 'PT', 6076),\n(174, 'Puerto Rico', 'Porto Rico', 'PR', 6114),\n(175, 'Qatar', 'Catar', 'QA', 1546),\n(176, 'Reunion', 'Reuni\u00e3o, Ilha', 'RE', 6602),\n(177, 'Romania', 'Rom\u00eania', 'RO', 6700),\n(178, 'Russian Federation', 'R\u00fassia, Federa\u00e7\u00e3o da', 'RU', 6769),\n(179, 'Rwanda', 'Ruanda', 'RW', 6750),\n(180, 'Saint Kitts and Nevis', 'S\u00e3o Cristov\u00e3o e Neves, Ilhas', 'KN', 6955),\n(181, 'Saint LUCIA', 'Santa Lucia', 'LC', 7153),\n(182, 'Saint Vincent and the Grenadines', 'S\u00e3o Vicente e Granadinas', 'VC', 7056),\n(183, 'Samoa', 'Samoa', 'WS', 6904),\n(184, 'San Marino', 'San Marino', 'SM', 6971),\n(185, 'Sao Tome and Principe', 'S\u00e3o Tome e Pr\u00edncipe, Ilhas', 'ST', 7200),\n(186, 'Saudi Arabia', 'Ar\u00e1bia Saudita', 'SA', 531),\n(187, 'Senegal', 'Senegal', 'SN', 7285),\n(188, 'Seychelles', 'Seychelles', 'SC', 7315),\n(189, 'Sierra Leone', 'Serra Leoa', 'SL', 7358),\n(190, 'Singapore', 'Cingapura', 'SG', 7412),\n(191, 'Slovakia (Slovak Republic)', 'Eslovaca, Republica', 'SK', 2470),\n(192, 'Slovenia', 'Eslov\u00eania, Republica da', 'SI', 2461),\n(193, 'Solomon Islands', 'Salom\u00e3o, Ilhas', 'SB', 6777),\n(194, 'Somalia', 'Somalia', 'SO', 7480),\n(195, 'South Africa', '\u00c1frica do Sul', 'ZA', 7560),\n(196, 'South Georgia and the South Sandwich Islands', 'Ilhas Ge\u00f3rgia do Sul e Sandwich do Sul', 'GS', 2925),\n(197, 'Spain', 'Espanha', 'ES', 2453),\n(198, 'Sri Lanka', 'Sri Lanka', 'LK', 7501),\n(199, 'St. Helena', 'Santa Helena', 'SH', 7102),\n(200, 'St. Pierre and Miquelon', 'S\u00e3o Pedro e Miquelon', 'PM', 7005),\n(201, 'Sudan', 'Sud\u00e3o', 'SD', 7595),\n(202, 'Suriname', 'Suriname', 'SR', 7706),\n(203, 'Svalbard and Jan Mayen Islands', 'Svalbard e Jan Mayen', 'SJ', 7552),\n(204, 'Swaziland', 'Eswatini', 'SZ', 7544),\n(205, 'Sweden', 'Su\u00e9cia', 'SE', 7641),\n(206, 'Switzerland', 'Su\u00ed\u00e7a', 'CH', 7676),\n(207, 'Syrian Arab Republic', 'S\u00edria, Republica \u00c1rabe da', 'SY', 7447),\n(208, 'Taiwan, Province of China', 'Formosa (Taiwan)', 'TW', 1619),\n(209, 'Tajikistan', 'Tadjiquistao, Republica do', 'TJ', 7722),\n(210, 'Tanzania, United Republic of', 'Tanz\u00e2nia, Republica Unida da', 'TZ', 7803),\n(211, 'Thailand', 'Tail\u00e2ndia', 'TH', 7765),\n(212, 'Togo', 'Togo', 'TG', 8001),\n(213, 'Tokelau', 'Toquelau, Ilhas', 'TK', 8052),\n(214, 'Tonga', 'Tonga', 'TO', 8109),\n(215, 'Trinidad and Tobago', 'Trinidad e Tobago', 'TT', 8150),\n(216, 'Tunisia', 'Tun\u00edsia', 'TN', 8206),\n(217, 'Turkey', 'Turquia', 'TR', 8273),\n(218, 'Turkmenistan', 'Turcomenist\u00e3o, Republica do', 'TM', 8249),\n(219, 'Turks and Caicos Islands', 'Turcas e Caicos, Ilhas', 'TC', 8230),\n(220, 'Tuvalu', 'Tuvalu', 'TV', 8281),\n(221, 'Uganda', 'Uganda', 'UG', 8338),\n(222, 'Ukraine', 'Ucr\u00e2nia', 'UA', 8311),\n(223, 'United Arab Emirates', 'Emirados \u00c1rabes Unidos', 'AE', 2445),\n(224, 'United Kingdom', 'Reino Unido', 'GB', 6289),\n(225, 'United States', 'Estados Unidos', 'US', 2496),\n(226, 'United States Minor Outlying Islands', 'Ilhas Menores Distantes dos Estados Unidos', 'UM', 18664),\n(227, 'Uruguay', 'Uruguai', 'UY', 8451),\n(228, 'Uzbekistan', 'Uzbequist\u00e3o, Republica do', 'UZ', 8478),\n(229, 'Vanuatu', 'Vanuatu', 'VU', 5517),\n(230, 'Venezuela', 'Venezuela', 'VE', 8508),\n(231, 'Viet Nam', 'Vietn\u00e3', 'VN', 8583),\n(232, 'Virgin Islands (British)', 'Virgens, Ilhas (Brit\u00e2nicas)', 'VG', 8630),\n(233, 'Virgin Islands (U.S.)', 'Virgens, Ilhas (E.U.A.)', 'VI', 8664),\n(234, 'Wallis and Futuna Islands', 'Wallis e Futuna, Ilhas', 'WF', 8753),\n(235, 'Western Sahara', 'Saara Ocidental', 'EH', 6858),\n(236, 'Yemen', 'I\u00e9men', 'YE', 3573),\n(237, 'Yugoslavia', 'Iugosl\u00e1via, Rep\u00fablica Fed. da', 'YU', 3883),\n(238, 'Zambia', 'Z\u00e2mbia', 'ZM', 8907),\n(239, 'Zimbabwe', 'Zimbabue', 'ZW', 6653),\n(240, 'Bailiwick of Guernsey', 'Guernsey, Ilha do Canal (Inclui Alderney e Sark)', 'GG', 1504),\n(241, 'Bailiwick of Jersey', 'Jersey, Ilha do Canal', 'JE', 1508),\n(243, 'Isle of Man', 'Man, Ilha de', 'IM', 3595),\n(246, 'Crna Gora (Montenegro)', 'Montenegro', 'ME', 4985),\n(247, 'S\u00c9RVIA', 'Republika Srbija', 'RS', 7370),\n(248, 'Republic of South Sudan', 'Sudao do Sul', 'SS', 7600),\n(249, 'Zona del Canal de Panam\u00e1', 'Zona do Canal do Panam\u00e1', NULL, 8958),\n(252, 'Dawlat Filas\u1e6d\u012bn', 'Palestina', 'PS', 5780),\n(253, '\u00c5land Islands', 'Aland, Ilhas', 'AX', 153),\n(255, 'Cura\u00e7ao', 'Cura\u00e7ao', 'CW', 200),\n(256, 'Saint Martin', 'S\u00e3o Martinho, Ilha de (Parte Holandesa)', 'SM', 6998),\n(258, 'Bonaire', 'Bonaire', 'AN', 990),\n(259, 'Antartica', 'Antartica', 'AQ', 420),\n(260, 'Heard Island and McDonald Islands', 'Ilha Herad e Ilhas Macdonald', 'AU', 3433),\n(261, 'Saint-Barth\u00e9lemy', 'S\u00e3o Bartolomeu', 'FR', 6939),\n(262, 'Saint Martin', 'S\u00e3o Martinho, Ilha de (Parte Francesa)', 'SM', 6980),\n(263, 'Terres Australes et Antarctiques Fran\u00e7aises', 'Terras Austrais e Ant\u00e1rcticas Francesas', 'TF', 7811);<\/code><\/pre>\n\n\n\n<p>Voc\u00ea pode inclusive fazer a rela\u00e7\u00e3o dos estados brasileiros com esta tabela, para isto, veja nosso outro post sobre a <a href=\"https:\/\/devtools.com.br\/blog\/tabela-de-estados-brasileiros\/\" target=\"_blank\" rel=\"noreferrer noopener\">lista de estados brasileiros<\/a>.<\/p>\n\n\n\n<p>Cr\u00e9ditos: <a href=\"https:\/\/github.com\/chinnonsantos\/sql-paises-estados-cidades\" target=\"_blank\" rel=\"noreferrer noopener\">@chinnonsantos<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Neste post trazemos a lista de pa\u00edses, com respetivo nome original, o nome em portugu\u00eas daquele pa\u00eds, a sigla e o c\u00f3digo internacional. A estrutura da tabela \u00e9: Para inser\u00e7\u00e3o dos registros, ou seja, todos os pa\u00edses, utilize o seguinte SQL: Voc\u00ea pode inclusive fazer a rela\u00e7\u00e3o dos estados brasileiros com esta tabela, para isto, &#8230; <a title=\"Tabela de Pa\u00edses\" class=\"read-more\" href=\"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/\" aria-label=\"More on Tabela de Pa\u00edses\">Ler mais<\/a><\/p>\n","protected":false},"author":1,"featured_media":1306,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[272],"tags":[],"class_list":["post-1295","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-banco-de-dados"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Tabela de Pa\u00edses<\/title>\n<meta name=\"description\" content=\"Tabela de todos os pa\u00edses do mundo, com estrutura SQL da tabela e tamb\u00e9m o insert com todos os registros.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/\" \/>\n<meta property=\"og:locale\" content=\"pt_BR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tabela de Pa\u00edses\" \/>\n<meta property=\"og:description\" content=\"Tabela de todos os pa\u00edses do mundo, com estrutura SQL da tabela e tamb\u00e9m o insert com todos os registros.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/\" \/>\n<meta property=\"og:site_name\" content=\"Devtools\" \/>\n<meta property=\"article:published_time\" content=\"2021-08-27T16:12:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-08-01T22:52:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/08\/tabela-de-paises.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"904\" \/>\n\t<meta property=\"og:image:height\" content=\"460\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Fabiano Abreu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fabiano Abreu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. tempo de leitura\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/\"},\"author\":{\"name\":\"Fabiano Abreu\",\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed\"},\"headline\":\"Tabela de Pa\u00edses\",\"datePublished\":\"2021-08-27T16:12:35+00:00\",\"dateModified\":\"2022-08-01T22:52:08+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/\"},\"wordCount\":78,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed\"},\"image\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/08\/tabela-de-paises.webp\",\"articleSection\":[\"Banco de Dados\"],\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/\",\"url\":\"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/\",\"name\":\"Tabela de Pa\u00edses\",\"isPartOf\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/08\/tabela-de-paises.webp\",\"datePublished\":\"2021-08-27T16:12:35+00:00\",\"dateModified\":\"2022-08-01T22:52:08+00:00\",\"description\":\"Tabela de todos os pa\u00edses do mundo, com estrutura SQL da tabela e tamb\u00e9m o insert com todos os registros.\",\"breadcrumb\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/#breadcrumb\"},\"inLanguage\":\"pt-BR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/#primaryimage\",\"url\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/08\/tabela-de-paises.webp\",\"contentUrl\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/08\/tabela-de-paises.webp\",\"width\":904,\"height\":460,\"caption\":\"Tabela de Pa\u00edses\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/devtools.com.br\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tabela de Pa\u00edses\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/devtools.com.br\/blog\/#website\",\"url\":\"https:\/\/devtools.com.br\/blog\/\",\"name\":\"Devtools\",\"description\":\"Sua caixa de ferramentas online\",\"publisher\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/devtools.com.br\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"pt-BR\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed\",\"name\":\"Fabiano Abreu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pt-BR\",\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2022\/07\/Fabiano-Abreu.png\",\"contentUrl\":\"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2022\/07\/Fabiano-Abreu.png\",\"width\":184,\"height\":184,\"caption\":\"Fabiano Abreu\"},\"logo\":{\"@id\":\"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/devtools.com.br\/blog\"],\"url\":\"https:\/\/devtools.com.br\/blog\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Tabela de Pa\u00edses","description":"Tabela de todos os pa\u00edses do mundo, com estrutura SQL da tabela e tamb\u00e9m o insert com todos os registros.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/","og_locale":"pt_BR","og_type":"article","og_title":"Tabela de Pa\u00edses","og_description":"Tabela de todos os pa\u00edses do mundo, com estrutura SQL da tabela e tamb\u00e9m o insert com todos os registros.","og_url":"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/","og_site_name":"Devtools","article_published_time":"2021-08-27T16:12:35+00:00","article_modified_time":"2022-08-01T22:52:08+00:00","og_image":[{"width":904,"height":460,"url":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/08\/tabela-de-paises.webp","type":"image\/webp"}],"author":"Fabiano Abreu","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Fabiano Abreu","Est. tempo de leitura":"10 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/#article","isPartOf":{"@id":"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/"},"author":{"name":"Fabiano Abreu","@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed"},"headline":"Tabela de Pa\u00edses","datePublished":"2021-08-27T16:12:35+00:00","dateModified":"2022-08-01T22:52:08+00:00","mainEntityOfPage":{"@id":"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/"},"wordCount":78,"commentCount":0,"publisher":{"@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed"},"image":{"@id":"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/#primaryimage"},"thumbnailUrl":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/08\/tabela-de-paises.webp","articleSection":["Banco de Dados"],"inLanguage":"pt-BR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/devtools.com.br\/blog\/tabela-de-paises\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/","url":"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/","name":"Tabela de Pa\u00edses","isPartOf":{"@id":"https:\/\/devtools.com.br\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/#primaryimage"},"image":{"@id":"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/#primaryimage"},"thumbnailUrl":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/08\/tabela-de-paises.webp","datePublished":"2021-08-27T16:12:35+00:00","dateModified":"2022-08-01T22:52:08+00:00","description":"Tabela de todos os pa\u00edses do mundo, com estrutura SQL da tabela e tamb\u00e9m o insert com todos os registros.","breadcrumb":{"@id":"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/#breadcrumb"},"inLanguage":"pt-BR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/devtools.com.br\/blog\/tabela-de-paises\/"]}]},{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/#primaryimage","url":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/08\/tabela-de-paises.webp","contentUrl":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2021\/08\/tabela-de-paises.webp","width":904,"height":460,"caption":"Tabela de Pa\u00edses"},{"@type":"BreadcrumbList","@id":"https:\/\/devtools.com.br\/blog\/tabela-de-paises\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/devtools.com.br\/blog\/"},{"@type":"ListItem","position":2,"name":"Tabela de Pa\u00edses"}]},{"@type":"WebSite","@id":"https:\/\/devtools.com.br\/blog\/#website","url":"https:\/\/devtools.com.br\/blog\/","name":"Devtools","description":"Sua caixa de ferramentas online","publisher":{"@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/devtools.com.br\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"pt-BR"},{"@type":["Person","Organization"],"@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/aa3425fdfdefa404466fc49f6d122eed","name":"Fabiano Abreu","image":{"@type":"ImageObject","inLanguage":"pt-BR","@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/image\/","url":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2022\/07\/Fabiano-Abreu.png","contentUrl":"https:\/\/devtools.com.br\/blog\/wp-content\/uploads\/2022\/07\/Fabiano-Abreu.png","width":184,"height":184,"caption":"Fabiano Abreu"},"logo":{"@id":"https:\/\/devtools.com.br\/blog\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/devtools.com.br\/blog"],"url":"https:\/\/devtools.com.br\/blog\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/posts\/1295","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/comments?post=1295"}],"version-history":[{"count":6,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/posts\/1295\/revisions"}],"predecessor-version":[{"id":1604,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/posts\/1295\/revisions\/1604"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/media\/1306"}],"wp:attachment":[{"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/media?parent=1295"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/categories?post=1295"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devtools.com.br\/blog\/wp-json\/wp\/v2\/tags?post=1295"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}