Subversion Repositories Sigmater

Rev

Blame | Last modification | View Log | Download | RSS feed

LOAD DATA
INFILE *
INSERT INTO TABLE S3_SS14T_PROT_TAB_COD
Fields terminated by ";" Optionally enclosed by '"'
(
  SS14_NOME_TAB,
  SS14_PROT_ULTIMO_AGG NULLIF (SS14_PROT_ULTIMO_AGG="NULL"),
  SS14_CREA_IN_ORDINE NULLIF (SS14_CREA_IN_ORDINE="NULL")
)
BEGINDATA
"S3_AA01G_Comuni";1;1;
"S3_AA02G_Province";1;2;
"S3_AA03G_Regioni";1;3;
"S3_CT03T_COD_Diritti";1;4;
"S3_CT07T_Strade_Cat";1;7;
"S3_AA05T_COD_Stato_Com";1;5;
"S3_CT23T_COD_Toponimi_Cat";1;6;
"S3_CT41T_COD_Tipo_Nota";1;11;
"S3_CT25T_COD_Riserve";1;8;
"S3_CT27T_COD_Qualita_Terreni";1;9;
"S3_CT40T_COD_Stato_Ident";1;10;
"S3_CT42T_COD_Regime";1;12;
"S3_CT46T_COD_Categorie";1;13;
"S3_CT47T_COD_Tipi_Protocollo";1;14;
"S3_CT49T_COD_Simboli";1;15;
"S3_CT55T_COD_Linee";1;16;
"S3_CT57T_COD_Attend_Plan_Ril";1;17;
"S3_CT58T_COD_Attend_Plan_Rete";1;18;
"S3_CT59T_COD_Attend_Quota_Ril";1;19;
"S3_CT60T_COD_Attend_Quota_Rete";1;20;
"S3_CT61T_COD_Causale";1;21;
"S3_SC03T_COD_Tipo_Sez";1;22;
"S3_SC04T_COD_Tipo_Loc_Istat";1;23;
"S3_SS03T_Enti";1;26;
"S3_SS04T_COD_Area_Tem";1;24;
"S3_SS01T_Aree_Sincrone";1;25;
"S3_SS02T_Prot_Sinteg";1;0;
"S3_CT13T_Tariffe_Terreni";1;27;
"S3_CT05T_Tariffe_Urbane";1;28;
"S3_CT39T_Valore_Deduzioni";1;29;
"S3_TI07T_PROTOCOLLI";1;0;
"S3_AA04G_COMUNITA_MONT";1;4;
"S3_CT62T_COD_PART_SPEC_UIU";1;40;
"S3_CT63T_COD_PART_SPEC_TERRENI";1;45;