shell 讀取文本並訪問mysql

標籤：where   class   code   base   執行   null   end   shel   sql   

#!/bin/bashFile="redeemcode.csv"#File=$1database="d_redeem_info"echo "check redeemcode state begin..."while read linedoif [ -z "$line" ];then echo "is null"else #rlt=`mysql -D $database -h127.0.0.1 -uroot -proot -e "select * from  t_redeem_code where c_redeem_code = ‘${line}‘;" ` rlt=$(mysql -D $database -h127.0.0.1 -uroot -proot -e "select * from  t_redeem_code where c_redeem_code = ‘${line}‘;" )fidone < ${File}echo "check redeemcode state end..."

shell傳參：$0 為執行的檔案名稱，$n，n代表第幾個參數

讀檔案：

while read linedo  echo $linedone < ${File}

邏輯判斷：

if [ -z "$line" ];then echo "is null"else echo "not null"fi

接收mysql操作傳回值：

rlt=‘mysql -h ......‘rlt=$(mysql -h ......)

shell 讀取文本並訪問mysql