Subversion Repositories Sigmater

Rev

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

LOAD DATA
INFILE *
INSERT INTO TABLE S3_AA02G_PROVINCE
Fields terminated by ";" Optionally enclosed by '"'
(
  AA02_COD_PROV_ISTAT,
  AA02_NOME,
  AA02_COD_REG_ISTAT,
  AA02_SIGLA
)
BEGINDATA
"001";"TORINO";"01";"TO"
"002";"VERCELLI";"01";"VC"
"003";"NOVARA";"01";"NO"
"004";"CUNEO";"01";"CN"
"005";"ASTI";"01";"AT"
"006";"ALESSANDRIA";"01";"AL"
"096";"BIELLA";"01";"BI"
"103";"VERBANO-CUSIO-OSSOLA";"01";"VB"
"007";"AOSTA";"02";"AO"
"012";"VARESE";"03";"VA"
"013";"COMO";"03";"CO"
"014";"SONDRIO";"03";"SO"
"015";"MILANO";"03";"MI"
"016";"BERGAMO";"03";"BG"
"017";"BRESCIA";"03";"BS"
"018";"PAVIA";"03";"PV"
"019";"CREMONA";"03";"CR"
"020";"MANTOVA";"03";"MN"
"097";"LECCO";"03";"LC"
"098";"LODI";"03";"LO"
"021";"BOLZANO";"04";"BZ"
"022";"TRENTO";"04";"TN"
"023";"VERONA";"05";"VR"
"024";"VICENZA";"05";"VI"
"025";"BELLUNO";"05";"BL"
"026";"TREVISO";"05";"TV"
"027";"VENEZIA";"05";"VE"
"028";"PADOVA";"05";"PD"
"029";"ROVIGO";"05";"RO"
"030";"UDINE";"06";"UD"
"031";"GORIZIA";"06";"GO"
"032";"TRIESTE";"06";"TS"
"093";"PORDENONE";"06";"PN"
"008";"IMPERIA";"07";"IM"
"009";"SAVONA";"07";"SV"
"010";"GENOVA";"07";"GE"
"011";"LA SPEZIA";"07";"SP"
"033";"PIACENZA";"08";"PC"
"034";"PARMA";"08";"PR"
"035";"REGGIO NELL'EMILIA";"08";"RE"
"036";"MODENA";"08";"MO"
"037";"BOLOGNA";"08";"BO"
"038";"FERRARA";"08";"FE"
"039";"RAVENNA";"08";"RA"
"040";"FORLI - CESENA";"08";"FC"
"099";"RIMINI";"08";"RN"
"045";"MASSA - CARRARA";"09";"MS"
"046";"LUCCA";"09";"LU"
"047";"PISTOIA";"09";"PT"
"048";"FIRENZE";"09";"FI"
"049";"LIVORNO";"09";"LI"
"050";"PISA";"09";"PI"
"051";"AREZZO";"09";"AR"
"052";"SIENA";"09";"SI"
"053";"GROSSETO";"09";"GR"
"100";"PRATO";"09";"PO"
"054";"PERUGIA";"10";"PG"
"055";"TERNI";"10";"TR"
"041";"PESARO E URBINO";"11";"PU"
"042";"ANCONA";"11";"AN"
"043";"MACERATA";"11";"MC"
"044";"ASCOLI PICENO";"11";"AP"
"056";"VITERBO";"12";"VT"
"057";"RIETI";"12";"RI"
"058";"ROMA";"12";"RM"
"059";"LATINA";"12";"LT"
"060";"FROSINONE";"12";"FR"
"066";"L'AQUILA";"13";"AQ"
"067";"TERAMO";"13";"TE"
"068";"PESCARA";"13";"PE"
"069";"CHIETI";"13";"CH"
"070";"CAMPOBASSO";"14";"CB"
"094";"ISERNIA";"14";"IS"
"061";"CASERTA";"15";"CE"
"062";"BENEVENTO";"15";"BN"
"063";"NAPOLI";"15";"NA"
"064";"AVELLINO";"15";"AV"
"065";"SALERNO";"15";"SA"
"071";"FOGGIA";"16";"FG"
"072";"BARI";"16";"BA"
"073";"TARANTO";"16";"TA"
"074";"BRINDISI";"16";"BR"
"075";"LECCE";"16";"LE"
"076";"POTENZA";"17";"PZ"
"077";"MATERA";"17";"MT"
"078";"COSENZA";"18";"CS"
"079";"CATANZARO";"18";"CZ"
"080";"REGGIO DI CALABRIA";"18";"RC"
"101";"CROTONE";"18";"KR"
"102";"VIBO VALENTIA";"18";"VV"
"081";"TRAPANI";"19";"TP"
"082";"PALERMO";"19";"PA"
"083";"MESSINA";"19";"ME"
"084";"AGRIGENTO";"19";"AG"
"085";"CALTANISSETTA";"19";"CL"
"086";"ENNA";"19";"EN"
"087";"CATANIA";"19";"CT"
"088";"RAGUSA";"19";"RG"
"089";"SIRACUSA";"19";"SR"
"090";"SASSARI";"20";"SS"
"091";"NUORO";"20";"NU"
"092";"CAGLIARI";"20";"CA"
"095";"ORISTANO";"20";"OR"
"000";"FITTIZIA";"00";"__"