Ubuntu

list="file1 file2"
for this in $list;do
    if [ -f "$this" ]
    then    echo "Downloading: $this"
    else    continue
    fi
done

#!/bin/bash

for i in {20151101..20151127}; do

mkdir -p /tmp/zip;

wget -qq ftp://ftp_user:ftp_pass@ftp.twt.it/TEKNONET/60468/0000060468"$i"N001.Zip -P /tmp/zip;

mkdir -p /tmp/cdr;

unzip -qq /tmp/zip/0000060468"$i"N001.Zip -d /tmp/cdr;


START=`echo $1 | tr -d _`;

TABLE_NAME=M"$i";


echo "Tabella del mese: "$TABLE_NAME;

if [ -f "/var/lib/mysql/twt/"$TABLE_NAME".frm" ] 
    then echo "Tabella esistente: OK"
    
else 
    echo "Tabella non esistente, la creo";
    SQL="create table "$TABLE_NAME"
    (WHSSID int not null,
     Seriale int not null,
     DataOra datetime,
     Chiamante text,
     Chiamato text,
     Prefisso_num_chiamato int,
     Descr_prefisso_chiamato varchar(50),
     Durata_secondi int,
     Costo_conversazione text,
     Chiamata_urb_extraurb int,
     Chiamata_voce_dati int,
     Chiamata_intratwt int,
     Prefisso_carrier_destinazione int);";
    echo $SQL > /tmp/sql;
    mysql -D twt -u root -pp1ngu1n0 < /tmp/sql;
fi

SQL="load data local infile '/tmp/cdr/0000060468"$i"N001.CDR' INTO TABLE $TABLE_NAME 

FIELDS TERMINATED BY ';' LINES TERMINATED BY '\n'";

echo $SQL > /tmp/sql;

mysql -u root -ppassword --local-infile twt < /tmp/sql;

rm -rf /tmp/*

done

Do
Wget
Done

For x in ()
Do
Load data infile
Done