Icomanda.comSql No Pass

frog · Jun 14, 2023

icomanda.com

format: sql
row: 20k
date: 06-2023

INSERT INTO customer_provider (id, cliente_vekttor_id, origem_cliente_vekttor_id, user_id, social_reason, fantasy_name, contact_name, activity_branch, birth, cnpj_cpf, rg, local_emission, suframa, municipal_registration, state_registration, email, ddd1, telefone1, ddd2, telefone2, fax, cep, address, home_number , complemento, district, city, state, sex, monthly_value, filiacao_pai, filiacao_mother, status, usuario_id_acesso, password_site, data_registration, vekttor_id, obs, contato_cliente_id, rate_delivery, mean_delivery_time, origin_contact_id, perc_discount, status_cliente, integration_id, integration_type) VALUES

Sample:

HTML:

(41, 249, 0, 0, 'Caroline Frutuoso', 'Caroline Frutuoso', 'Caroline Frutuoso', '', '0000-00-00', '', '', '', '', '', '', 'aynacaroline@hotmail.com', '92', '98203-9301', '92', '98203-9301', '', '69053090', 'Rua Libertador', '939', 'CaSa  - Em frente a praça', 'Nossa Senhora Das Graças', 'Manaus', 'Amazonas', -3.11113, -60.02124, '', 'Cliente', 'Físico', '', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '', 1, '', 'm', 0, '', '', '1', 0, '', '2020-09-15 04:00:00', 0, '', 0, 1, '00:00:00', 1, 0, 'ativo', '', ''),
(42, 249, 0, NULL, 'Cecilia Karoline', 'Cecilia Karoline', 'Cecilia Karoline', NULL, '0000-00-00', '', NULL, NULL, NULL, NULL, NULL, '', '92', '99317-6521', '92', '99317-6521', NULL, '69000-00', 'Rua 21', '829', 'conj castelo branco', 'Parque 10', 'Manaus', 'Amazonas', 0, 0, NULL, 'Cliente', 'Físico', NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '0000-00-00', '', '0000-00-00', '0000-00-00', '', NULL, '', '', '', '', NULL, 1, '', 'm', 0, '', '', '1', 0, '', '2020-09-15 04:00:00', 0, '', 0, 30, '00:00:00', 1, 0, 'ativo', '', ''),
(43, 249, 0, 0, 'Celianne Marcelino de Melo', 'Celianne Marcelino de Melo', 'Celianne Marcelino de Melo', '', '0000-00-00', '', '', '', '', '', '', 'celiannemelo@gmail.com', '92', '99123-0206', '92', '99123-0206', '', '69078560', 'Rua Américo Alvarez', '55-A', 'Apt  - Frigobom ', 'Japiim', 'Manaus', 'Amazonas', -3.11663, -59.99057, '', 'Cliente', 'Físico', '', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '', 1, '', 'm', 0, '', '', '1', 0, '', '2020-09-15 04:00:00', 0, '', 0, 1, '00:00:00', 1, 0, 'ativo', '', ''),
(44, 249, 0, NULL, 'Chris pimenta', 'Chris pimenta', 'Chris pimenta', NULL, '0000-00-00', '', NULL, NULL, NULL, NULL, NULL, NULL, '92', '98156-0886', '92', '98156-0886', NULL, '69000-00', 'Rua Cascalheira', '18', '', 'Lírio do Vale', 'Manaus', 'Amazonas', 0, 0, NULL, 'Cliente', 'Físico', NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '0000-00-00', '', '0000-00-00', '0000-00-00', '', NULL, '', '', '', '', NULL, 1, '', 'm', 0, '', '', '1', 0, '', '2020-09-15 04:00:00', 0, '', 0, 1, '00:00:00', 1, 0, 'ativo', '', ''),
(45, 249, 0, NULL, 'cilene neves', 'cilene neves', 'cilene neves', NULL, '0000-00-00', '', NULL, NULL, NULL, NULL, NULL, NULL, '92', '99292-6933', '92', '99292-6933', NULL, '69000-00', 'Rua huasca de angelin', '45', '', 'aleixo', 'Manaus', 'Amazonas', 0, 0, NULL, 'Cliente', 'Físico', NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '0000-00-00', '', '0000-00-00', '0000-00-00', '', NULL, '', '', '', '', NULL, 1, '', 'm', 0, '', '', '1', 0, '', '2020-09-15 04:00:00', 0, '', 0, 1, '00:00:00', 1, 0, 'ativo', '', ''),
(46, 249, 0, NULL, 'Claudia', 'Claudia', 'Claudia', NULL, '0000-00-00', '', NULL, NULL, NULL, NULL, NULL, NULL, '92', '98218-6551', '92', '98218-6551', NULL, '69000-00', 'Rua joao gomes', '1', '', 'Aguas claras', 'Manaus', 'Amazonas', 0, 0, NULL, 'Cliente', 'Físico', NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '0000-00-00', '', '0000-00-00', '0000-00-00', '', NULL, '', '', '', '', NULL, 1, '', 'm', 0, '', '', '1', 0, '', '2020-09-15 04:00:00', 0, '', 0, 1, '00:00:00', 1, 0, 'ativo', '', ''),
(47, 249, 0, 0, 'Yara de souza freitas', 'Yara de souza freitas', 'Yara de souza freitas', '', '0000-00-00', '', '', '', '', '', '', 'Yarasouza33@gmail.com', '92', '99460-8114', '92', '99460-8114', '', '69055220', 'Rua 4', '56', 'Prox a igreja São judas Tadeu\nCasa', 'Parque 10 de Novembro', 'Manaus', 'Amazonas', 0, 0, '', 'Cliente', 'Físico', '', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '0000-00-00', '0000-00-00', '', '', '', '', '', '', '', 1, '', 'm', 0, '', '', '1', 0, '', '2020-09-15 04:00:00', 0, '', 0, 31, '00:00:00', 1, 0, 'ativo', '', ''),
(48, 249, 0, NULL, 'CLIENTE 108', 'CLIENTE 108', 'CLIENTE 108', NULL, '0000-00-00', '', NULL, NULL, NULL, NULL, NULL, NULL, '92', '98125-6161', '92', '98125-6161', NULL, '69000-00', 'RUA 02', '02', '', 'PETROPOLIS', 'Manaus', 'Amazonas', 0, 0, NULL, 'Cliente', 'Físico', NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '0000-00-00', '', '0000-00-00', '0000-00-00', '', NULL, '', '', '', '', NULL, 1, '', 'm', 0, '', '', '1', 0, '', '2020-09-15 04:00:00', 0, '', 0, 1, '00:00:00', 1, 0, 'ativo', '', ''),
(49, 249, 0, NULL, 'CLIENTE SAFADO!', 'CLIENTE SAFADO!', 'CLIENTE SAFADO!', NULL, '0000-00-00', '', NULL, NULL, NULL, NULL, NULL, NULL, '92', '99248-4037', '92', '99248-4037', NULL, '69000-00', 'Rua 17', '102', '', 'Alvorada 2', 'Manaus', 'Amazonas', 0, 0, NULL, 'Cliente', 'Físico', NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '0000-00-00', '', '0000-00-00', '0000-00-00', '', NULL, '', '', '', '', NULL, 1, '', 'm', 0, '', '', '1', 0, '', '2020-09-15 04:00:00', 0, '', 0, 1, '00:00:00', 1, 0, 'ativo', '', ''),
(50, 249, 0, NULL, 'Clint Douglas', 'Clint Douglas', 'Clint Douglas', NULL, '0000-00-00', '', NULL, NULL, NULL, NULL, NULL, '', '92', '99171-7006', '92', '99171-7006', NULL, '69000-00', 'Rua Manoel Santos Júnior', '28', '', 'Parque 10 de Novembro', 'Manaus', 'Amazonas', 0, 0, NULL, 'Cliente', 'Físico', NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '0000-00-00', '', '0000-00-00', '0000-00-00', '', NULL, '', '', '', '', NULL, 1, '', 'm', 0, '', '', '1', 0, '', '2020-09-15 04:00:00', 0, '', 0, 30, '00:00:00', 1, 0, 'ativo', '', ''),

Hidden content

TimePeak · Jun 15, 2023

Thanks for sharing with us.

joseph.s · Jun 15, 2023

GREAT WORK

zul22 · Oct 12, 2023

frog said:
icomanda.com

formato: SQL
linha: 20k
data: 06-2023

INSERT INTO customer_provider (id, cliente_vekttor_id, origem_cliente_vekttor_id, user_id, social_reason, fantasy_name, contact_name, activity_branch, nascimento, cnpj_cpf, rg, local_emission, suframa, municipal_registration, state_registration, state_registration, email, ddd1, telefone1, ddd2, telefone2, fax, cep, endereço, home_number , complemento, distrito, cidade, estado, sexo, valor_mensal, filiacao_pai, filiacao_mother, status, usuario_id_acesso, senha_site, data_registration, vekttor_id, obs, contato_cliente_id, rate_delivery, mean_delivery_time, origin_contact_id, perc_discount, status_cliente, integração_id, integração_type) VALORES

Amostra:
[código]
(41, 249, 0, 0, 'Caroline Frutuoso', 'Caroline Frutuoso', 'Caroline Frutuoso', '', '0000-00-00', '', '', '', '', '', '', 'aynacaroline@hotmail.com', '92', '98203-9301', '92', '98203-9301', '', '69053090', 'Rua Libertador', '939', 'CaSa - Em frente a praça', 'Nossa Senhora Das Graças', 'Manaus', 'Amazonas', -3.11113, -60.02124, '', 'Cliente', 'Físico', '', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '0000-00-00', '0000-00-00', '', '' , '', '', '', '', '', 1,'', 'm', 0, '', '', '1', 0, '', '2020-09-15 04:00:00', 0, '', 0, 1, '00:00 :00', 1, 0, 'ativo', '', ''),
(42, 249, 0, NULL, 'Cecilia Karoline', 'Cecilia Karoline', 'Cecilia Karoline', NULL, '0000-00-00', '', NULL, NULL, NULL, NULL, NULL, '', '92', '99317-6521', '92', '99317-6521', NULL, '69000-00', 'Rua 21', '829', 'conj castelo branco', 'Parque 10', 'Manaus ', 'Amazonas', 0, 0, NULL, 'Cliente', 'Físico', NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '0000-00-00 ', '', '0000-00-00', '0000-00-00', '', NULO, '', '', '', '', NULO, 1, '', 'm', 0 , '', '', '1', 0, '', '2020-09-15 04:00:00', 0, '', 0, 30, '00:00:00', 1, 0,'ativo', '', ''),
(43, 249, 0, 0, 'Celianne Marcelino de Melo', 'Celianne Marcelino de Melo', 'Celianne Marcelino de Melo', '', '0000-00-00', '', '', '', '', '', '', 'celiannemelo@gmail.com', '92', '99123-0206', '92', '99123-0206', '', '69078560', 'Rua Américo Alvarez', '55-A', 'Apto - Frigobom ', 'Japiim', 'Manaus', 'Amazonas', -3.11663, -59.99057, '', 'Cliente', 'Físico', '', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '0000-00-00', '0000-00-00', '' , '', '', '', '', '', '', 1,'', 'm', 0, '', '', '1', 0, '', '2020-09-15 04:00:00', 0, '', 0, 1, '00:00 :00', 1, 0, 'ativo', '', ''),
(44, 249, 0, NULL, 'Chris pimenta', 'Chris pimenta', 'Chris pimenta', NULL, '0000-00-00', '', NULL, NULL, NULL, NULL, NULL, NULL, ' 92', '98156-0886', '92', '98156-0886', NULL, '69000-00', 'Rua Cascalheira', '18', '', 'Lírio do Vale', 'Manaus', ' Amazonas', 0, 0, NULL, 'Cliente', 'Físico', NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '0000-00-00', ' ', '0000-00-00', '0000-00-00', '', NULO, '', '', '', '', NULO, 1, '', 'm', 0, '' , '', '1', 0, '', '2020-09-15 04:00:00', 0, '', 0, 1, '00:00:00', 1, 0, 'ativo' , '',''),
(45, 249, 0, NULL, 'cilene neves', 'cilene neves', 'cilene neves', NULL, '0000-00-00', '', NULL, NULL, NULL, NULL, NULL, NULL, ' 92', '99292-6933', '92', '99292-6933', NULL, '69000-00', 'Rua huasca de angelin', '45', '', 'aleixo', 'Manaus', ' Amazonas', 0, 0, NULL, 'Cliente', 'Físico', NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '0000-00-00', ' ', '0000-00-00', '0000-00-00', '', NULO, '', '', '', '', NULO, 1, '', 'm', 0, '' , '', '1', 0, '', '2020-09-15 04:00:00', 0, '', 0, 1, '00:00:00', 1, 0, 'ativo' , '',''),
(46, 249, 0, NULO, 'Claudia', 'Claudia', 'Claudia', NULL, '0000-00-00', '', NULL, NULL, NULL, NULL, NULL, NULL, '92', '98218-6551', '92', '98218-6551', NULL, '69000-00', 'Rua João Gomes', '1', '', 'Águas claras', 'Manaus', 'Amazonas', 0, 0, NULL, 'Cliente', 'Físico', NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '0000-00-00', '', ' 0000-00-00', '0000-00-00', '', NULO, '', '', '', '', NULO, 1, '', 'm', 0, '', '' , '1', 0, '', '2020-09-15 04:00:00', 0, '', 0, 1, '00:00:00', 1, 0, 'ativo', '' , ''),
(47, 249, 0, 0, 'Yara de souza freitas', 'Yara de souza freitas', 'Yara de souza freitas', '', '0000-00-00', '', '', '', '', '', '', 'Yarasouza33@gmail.com', '92', '99460-8114', '92', '99460-8114', '', '69055220', 'Rua 4', ' 56', 'Prox a igreja São judas Tadeu\nCasa', 'Parque 10 de Novembro', 'Manaus', 'Amazonas', 0, 0, '', 'Cliente', 'Físico', '', '', '', '', '', '', '', '', '', '', '0000-00-00', '', '0000-00-00', '0000-00-00' , '', '', '', '', '', '', '', 1, '','m', 0, '', '', '1', 0, '', '2020-09-15 04:00:00', 0, '', 0, 31, '00:00:00' , 1, 0, 'ativo', '', ''),
(48, 249, 0, NULO, 'CLIENTE 108', 'CLIENTE 108', 'CLIENTE 108', NULO, '0000-00-00', '', NULO, NULO, NULO, NULO, NULO, NULO, ' 92', '98125-6161', '92', '98125-6161', NULL, '69000-00', 'RUA 02', '02', '', 'PETRÓPOLIS', 'Manaus', 'Amazonas' , 0, 0, NULL, 'Cliente', 'Físico', NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '0000-00-00', '', '0000-00-00', '0000-00-00', '', NULO, '', '', '', '', NULO, 1, '', 'm', 0, '', ' ', '1', 0, '', '2020-09-15 04:00:00', 0, '', 0, 1, '00:00:00', 1, 0, 'ativo', ' ', ''),
(49, 249, 0, NULL, 'CLIENTE SAFADO!', 'CLIENTE SAFADO!', 'CLIENTE SAFADO!', NULL, '0000-00-00', '', NULL, NULL, NULL, NULL, NULL, NULL, '92', '99248-4037', '92', '99248-4037', NULL, '69000-00', 'Rua 17', '102', '', 'Alvorada 2', 'Manaus' , 'Amazonas', 0, 0, NULL, 'Cliente', 'Físico', NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '0000-00-00' , '', '0000-00-00', '0000-00-00', '', NULO, '', '', '', '', NULO, 1, '', 'm', 0, '', '', '1', 0, '', '2020-09-15 04:00:00', 0, '', 0, 1, '00:00:00', 1, 0, ' ativo', '',''),
(50, 249, 0, NULL, 'Clint Douglas', 'Clint Douglas', 'Clint Douglas', NULL, '0000-00-00', '', NULL, NULL, NULL, NULL, NULL, '', '92', '99171-7006', '92', '99171-7006', NULL, '69000-00', 'Rua Manoel Santos Júnior', '28', '', 'Parque 10 de Novembro', ' Manaus', 'Amazonas', 0, 0, NULL, 'Cliente', 'Físico', NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', '0000-00- 00', '', '0000-00-00', '0000-00-00', '', NULO, '', '', '', '', NULO, 1, '', 'm', 0, '', '', '1', 0, '', '2020-09-15 04:00:00', 0, '', 0, 30, '00:00:00', 1, 0 ,'ativo', '', ''),
[/código]

[Conteúdo oculto]

Muito top mano

joseph.s said:
ÓTIMO TRABALHO

Muito excelente amigo

Icomanda.comSql No Pass

frog

TimePeak

joseph.s

zul22

Similar threads