arry=()
sql1="mysql语句; ";
ss1=(mysql−uDB_USER -h DBIP−p{DB_PASSWD} DBNAME−e"sql1"|awk 'NR>1');
if [ -n "$ss1" ]
then
arry[t]=$ss1
else
arry[t]=0
fi
done
echo i{arry[*]}>>123456.txt;
STARTDAY=20150101
ENDDAY=20150430
sd=`date -d "$STARTDAY" +%s`
ed=`date -d "$ENDDAY" +%s`
DAYLEN=((((ed−sd))/86400))
echo $DAYLEN
sday=`date -d "$STARTDAY" +%Y-%m-%d`
syesday=`date -d "$sday + 1 day" +%Y-%m-%d`
crry=()
for((t=0;t<=$DAYLEN;t++));
do
itoday=`date +%Y%m%d -d "sday+t days"`
crry[t]=$itoday
done
echo "UID"" "${crry[*]}>>123456.txt;
本文转自 chengxuyonghu 51CTO博客,原文链接:http://blog.51cto.com/6226001001/1656487,如需转载请自行联系原作者