shell插入遠端mysql資料

#!/bin/bash


dateT=`date  +"%Y-%m-%d"  -d  "-1 days"`
dateN=`date  +"%Y%m%d"  -d  "-1 days"`


DB=count
U=user
P=password
port=63305
H=ip
MYSQL="mysql --skip-column-names --default-character-set=utf8 -u$U -p$P -h $H -P$port $DB"


while read line
do
     id=$line
     rm -rf /data/test2/temp
     cat /data/prod1/*/*/*/$id/*$dateT* >>/data/test2/temp
     size=`du -k /data/test2/temp |awk '{print $1}'`
     leng=`cat /data/test2/temp |wc -l`
     val=$(echo $size $leng | awk '{ printf "%0.2f\n" ,$1/$2}')
$MYSQL <<E1
        insert into count_vip (app_id,created,size) VALUES($id,$dateN,$val); ;
E1
done < /usr/messageQuery/appKey