shell DB取出不同的字段

 

#!/bin/sh
export LD_LIBRARY_PATH=/usr/lib
DATE=`date +20%y%m%d`
DB_NAME=xxxx
DB_USER=xxxx
DB_PWD=xxxx
DB_HOST=xxxxx
mkdir -p /usr/local/tdb_admin/htdocs/chart/$DATE

 

NUM=`/usr/local/mysql/bin/mysql -h$DB_HOST -u$DB_USER -p$DB_PWD $DB_NAME -e "select Fgroup_id,Fbusiness_id from Tdb_bu_info
;"`
curtime=`date +%s`
currenttime=`expr $curtime `
endtime=`expr $currenttime - 86400`
COUNT=0
for j in $NUM
do
        COUNT=`expr $COUNT + 1`
done
i=3
while [ $i -le $COUNT ]
do
        num=$i
        export i
        Fgroup_id=`echo $NUM | awk 'BEGIN{n = ENVIRON["i"];} {print $n }'`
        i=`expr $i + 1`
        Fbusiness_id=`echo $NUM | awk 'BEGIN{n = ENVIRON["i"];} {print $n }'`
        i=`expr $i + 1`
        echo "$Fgroup_id, $Fbusiness_id"
        /usr/local/tdb_admin/cgi-bin/chart_size_increase $Fgroup_id $Fbusiness_id
done