#!/bin/bash entime="`date +'%Y-%m-%d'` 00:00" bgtime="`date +'%Y-%m-%d' -d '-1 days'` 00:00" date="`date +'%Y-%m-%d' -d '-1 days'`" conn="MysqL -h 127.0.0.1 -ul -P3306 -pl -Dtest --default-character-set=UTF8 --show-warnings=false" sql="select count(1) from h where F_time >= '"$bgtime"' and F_time < '"$entime"';" res1=$($conn -e "$sql") echo $sql echo "" echo "" res1=`echo $res1 | awk -F ' ' '{print $2}'` echo "数: " $res1 echo "" echo ""
原文链接：https://www.f2er.com/bash/388275.html
