shell脚本 根据文本数据，更新mysql表数据

#!bin/bash

  cat lixian.txt.res | while read line
  do
        vid=`echo $line | awk -F " " '{print $1}'`
        ti=`echo $line | awk -F " " '{print $2}'`
        lastmileage=`echo $line | awk -F " " '{print $4}'`
	
	lasttime=`echo ${ti:0:4}"-"${ti:4:2}"-"${ti:6:2}" "${ti:8:2}":"${ti:10:2}":"${ti:12:2}`
	#echo "$vid"
	#echo "$lastmileage"
	if [ "$lastmileage" != "" ]
	then
	    #mysql -h'192.168.1.106' -u'dev' -p'dev' -D'evsmc_cs' << eof

	    echo "update sys_veh_idle_record set last_online_mileage=$lastmileage where vehicle_uuid='"$vid"' and last_online_time='"$lasttime"';"	
	    update_sql="update sys_veh_idle_record set last_online_mileage=${lastmileage} where vehicle_uuid='"${vid}"' and last_online_time='"${lasttime}"';"

	   mysql -h'192.168.1.106' -P'3306' -u'dev' -p'dev' 'evsmc_cs' -e"${update_sql}"
	fi

  done