• Home
• Sobre

Criei um planilha que concatena variáveis e constantes tendo objetivo de criar as Query’s  dos Estados brasileiros.

Compartilho o modelo esperando que seja útil também em outro momento e mostrando que panílhas eletrônicas não são apenas para cálculos, mas nos ajudam a programar.

Planilha download (14 KB)

Query’s para inserção dos Estados brasileiros no prestashop:

INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Acre","AC", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Alagoas","AL", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Amapá","AP", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Amazonas","AM", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Bahia","BA", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Ceará","CE", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Distrito Federal","DF", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Espírito Santo","ES", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Goiás","GO", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Maranhão","MA", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Mato Grosso","MT", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Mato Grosso do Sul","MS", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Minas Gerais","MG", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Pará","PA", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Paraíba","PB", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Paraná","PR", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Pernambuco","PE", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Piauí","PI", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Rio de Janeiro","RJ", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Rio Grande do Norte","RN", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Rio Grande do Sul","RS", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Rondônia","RO", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Roraima","RR", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Santa Catarina","SC", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"São Paulo","SP", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Sergipe","SE", 0, 1);
INSERT INTO ps_state (id_country, id_zone, name, iso_code, tax_behavior, active) VALUES (58, 6,"Tocantins","TO", 0, 1);

Comentários

Ainda não há comentários.

Escreva um Comentário