Blame | Last modification | View Log | Download | RSS feed
LOAD DATA
INFILE *
INSERT INTO TABLE S3_AA03G_REGIONI
Fields terminated by ";" Optionally enclosed by '"'
(
AA03_COD_REG_ISTAT,
AA03_NOME
)
BEGINDATA
"02";"VALLE D'AOSTA"
"03";"LOMBARDIA"
"04";"TRENTINO ALTO ADIGE"
"05";"VENETO"
"06";"FRIULI VENEZIA GIULIA"
"07";"LIGURIA"
"08";"EMILIA-ROMAGNA"
"09";"TOSCANA"
"10";"UMBRIA"
"11";"MARCHE"
"12";"LAZIO"
"13";"ABRUZZO"
"14";"MOLISE"
"15";"CAMPANIA"
"16";"PUGLIA"
"17";"BASILICATA"
"18";"CALABRIA"
"19";"SICILIA"
"20";"SARDEGNA"
"00";"FITTIZIA"
"01";"PIEMONTE"