GABRIEL MEINBERG RENO meinreno
EthraZa
/ DTB_2014_Municipios.sql
Last active
May 10, 2021 04:17
Tabela simples (MySQL) com a lista atualizada de Códigos de Municípios do IBGE, com 7 dígitos, baseada na lista 2014 v2 em ftp://geoftp.ibge.gov.br/organizacao_territorial/divisao_territorial/2014/
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE IF NOT EXISTS `municipios` ( | |
| `id` int(7) NOT NULL, | |
| `estado` varchar(19) COLLATE utf8_unicode_ci DEFAULT NULL, | |
| `uf` char(2) COLLATE utf8_unicode_ci DEFAULT NULL, | |
| `municipio` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL | |
| PRIMARY KEY (`id`) | |
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; | |
| INSERT INTO `municipios` (`id`, `estado`, `uf`, `municipio`) VALUES | |
| (1100015, 'Rondônia', 'RO', 'Alta Floresta D\'Oeste'), |
cassiocardoso
/ select-estados-br
Created
February 12, 2014 23:31
Select com uma lista de todos os estados brasileiros.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <select name="estados-brasil"> | |
| <option value="AC">Acre</option> | |
| <option value="AL">Alagoas</option> | |
| <option value="AP">Amapá</option> | |
| <option value="AM">Amazonas</option> | |
| <option value="BA">Bahia</option> | |
| <option value="CE">Ceará</option> | |
| <option value="DF">Distrito Federal</option> | |
| <option value="ES">Espírito Santo</option> | |
| <option value="GO">Goiás</option> |