shell 操作mysql

#!/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 ""