Details | Last modification | View Log | RSS feed
| Rev | Author | Line No. | Line |
|---|---|---|---|
| 6 | Andrea | 1 | LOAD DATA |
| 2 | INFILE * |
||
| 3 | INSERT INTO TABLE S3_AA02G_PROVINCE |
||
| 4 | Fields terminated by ";" Optionally enclosed by '"' |
||
| 5 | ( |
||
| 6 | AA02_COD_PROV_ISTAT, |
||
| 7 | AA02_NOME, |
||
| 8 | AA02_COD_REG_ISTAT, |
||
| 9 | AA02_SIGLA |
||
| 10 | ) |
||
| 11 | BEGINDATA |
||
| 12 | "001";"TORINO";"01";"TO" |
||
| 13 | "002";"VERCELLI";"01";"VC" |
||
| 14 | "003";"NOVARA";"01";"NO" |
||
| 15 | "004";"CUNEO";"01";"CN" |
||
| 16 | "005";"ASTI";"01";"AT" |
||
| 17 | "006";"ALESSANDRIA";"01";"AL" |
||
| 18 | "096";"BIELLA";"01";"BI" |
||
| 19 | "103";"VERBANO-CUSIO-OSSOLA";"01";"VB" |
||
| 20 | "007";"AOSTA";"02";"AO" |
||
| 21 | "012";"VARESE";"03";"VA" |
||
| 22 | "013";"COMO";"03";"CO" |
||
| 23 | "014";"SONDRIO";"03";"SO" |
||
| 24 | "015";"MILANO";"03";"MI" |
||
| 25 | "016";"BERGAMO";"03";"BG" |
||
| 26 | "017";"BRESCIA";"03";"BS" |
||
| 27 | "018";"PAVIA";"03";"PV" |
||
| 28 | "019";"CREMONA";"03";"CR" |
||
| 29 | "020";"MANTOVA";"03";"MN" |
||
| 30 | "097";"LECCO";"03";"LC" |
||
| 31 | "098";"LODI";"03";"LO" |
||
| 32 | "021";"BOLZANO";"04";"BZ" |
||
| 33 | "022";"TRENTO";"04";"TN" |
||
| 34 | "023";"VERONA";"05";"VR" |
||
| 35 | "024";"VICENZA";"05";"VI" |
||
| 36 | "025";"BELLUNO";"05";"BL" |
||
| 37 | "026";"TREVISO";"05";"TV" |
||
| 38 | "027";"VENEZIA";"05";"VE" |
||
| 39 | "028";"PADOVA";"05";"PD" |
||
| 40 | "029";"ROVIGO";"05";"RO" |
||
| 41 | "030";"UDINE";"06";"UD" |
||
| 42 | "031";"GORIZIA";"06";"GO" |
||
| 43 | "032";"TRIESTE";"06";"TS" |
||
| 44 | "093";"PORDENONE";"06";"PN" |
||
| 45 | "008";"IMPERIA";"07";"IM" |
||
| 46 | "009";"SAVONA";"07";"SV" |
||
| 47 | "010";"GENOVA";"07";"GE" |
||
| 48 | "011";"LA SPEZIA";"07";"SP" |
||
| 49 | "033";"PIACENZA";"08";"PC" |
||
| 50 | "034";"PARMA";"08";"PR" |
||
| 51 | "035";"REGGIO NELL'EMILIA";"08";"RE" |
||
| 52 | "036";"MODENA";"08";"MO" |
||
| 53 | "037";"BOLOGNA";"08";"BO" |
||
| 54 | "038";"FERRARA";"08";"FE" |
||
| 55 | "039";"RAVENNA";"08";"RA" |
||
| 56 | "040";"FORLI - CESENA";"08";"FC" |
||
| 57 | "099";"RIMINI";"08";"RN" |
||
| 58 | "045";"MASSA - CARRARA";"09";"MS" |
||
| 59 | "046";"LUCCA";"09";"LU" |
||
| 60 | "047";"PISTOIA";"09";"PT" |
||
| 61 | "048";"FIRENZE";"09";"FI" |
||
| 62 | "049";"LIVORNO";"09";"LI" |
||
| 63 | "050";"PISA";"09";"PI" |
||
| 64 | "051";"AREZZO";"09";"AR" |
||
| 65 | "052";"SIENA";"09";"SI" |
||
| 66 | "053";"GROSSETO";"09";"GR" |
||
| 67 | "100";"PRATO";"09";"PO" |
||
| 68 | "054";"PERUGIA";"10";"PG" |
||
| 69 | "055";"TERNI";"10";"TR" |
||
| 70 | "041";"PESARO E URBINO";"11";"PU" |
||
| 71 | "042";"ANCONA";"11";"AN" |
||
| 72 | "043";"MACERATA";"11";"MC" |
||
| 73 | "044";"ASCOLI PICENO";"11";"AP" |
||
| 74 | "056";"VITERBO";"12";"VT" |
||
| 75 | "057";"RIETI";"12";"RI" |
||
| 76 | "058";"ROMA";"12";"RM" |
||
| 77 | "059";"LATINA";"12";"LT" |
||
| 78 | "060";"FROSINONE";"12";"FR" |
||
| 79 | "066";"L'AQUILA";"13";"AQ" |
||
| 80 | "067";"TERAMO";"13";"TE" |
||
| 81 | "068";"PESCARA";"13";"PE" |
||
| 82 | "069";"CHIETI";"13";"CH" |
||
| 83 | "070";"CAMPOBASSO";"14";"CB" |
||
| 84 | "094";"ISERNIA";"14";"IS" |
||
| 85 | "061";"CASERTA";"15";"CE" |
||
| 86 | "062";"BENEVENTO";"15";"BN" |
||
| 87 | "063";"NAPOLI";"15";"NA" |
||
| 88 | "064";"AVELLINO";"15";"AV" |
||
| 89 | "065";"SALERNO";"15";"SA" |
||
| 90 | "071";"FOGGIA";"16";"FG" |
||
| 91 | "072";"BARI";"16";"BA" |
||
| 92 | "073";"TARANTO";"16";"TA" |
||
| 93 | "074";"BRINDISI";"16";"BR" |
||
| 94 | "075";"LECCE";"16";"LE" |
||
| 95 | "076";"POTENZA";"17";"PZ" |
||
| 96 | "077";"MATERA";"17";"MT" |
||
| 97 | "078";"COSENZA";"18";"CS" |
||
| 98 | "079";"CATANZARO";"18";"CZ" |
||
| 99 | "080";"REGGIO DI CALABRIA";"18";"RC" |
||
| 100 | "101";"CROTONE";"18";"KR" |
||
| 101 | "102";"VIBO VALENTIA";"18";"VV" |
||
| 102 | "081";"TRAPANI";"19";"TP" |
||
| 103 | "082";"PALERMO";"19";"PA" |
||
| 104 | "083";"MESSINA";"19";"ME" |
||
| 105 | "084";"AGRIGENTO";"19";"AG" |
||
| 106 | "085";"CALTANISSETTA";"19";"CL" |
||
| 107 | "086";"ENNA";"19";"EN" |
||
| 108 | "087";"CATANIA";"19";"CT" |
||
| 109 | "088";"RAGUSA";"19";"RG" |
||
| 110 | "089";"SIRACUSA";"19";"SR" |
||
| 111 | "090";"SASSARI";"20";"SS" |
||
| 112 | "091";"NUORO";"20";"NU" |
||
| 113 | "092";"CAGLIARI";"20";"CA" |
||
| 114 | "095";"ORISTANO";"20";"OR" |
||
| 115 | "000";"FITTIZIA";"00";"__" |