shell 中调用 mysql 操作

#!/bin/bash
#删除100个数据库中的1000个表的过期数据
DBHOST="127.0.0.1"
DBPWD="pwd"
DBUSER="root"
MYSQLBIN="/usr/local/mysql/bin/mysql"

for((dbindex = 0;dbindex < 100;dbindex++))
do
   for((tabindex = 0;tabindex < 10;tabindex++))
   do
    if [ $dbindex -lt 10 ]; then
  del="delete from gs_map_0${dbindex}.t_${tabindex}";
    else
  del="delete from gs_map_${dbindex}.t_${tabindex}";
    fi
    del=${del}" where Fcreate_time < UNIX_TIMESTAMP() - 86400"
    bin=`${MYSQLBIN} -u${DBUSER} -p${DBPWD} -h${DBHOST} -e"${del}"`
    $bin
    #echo ${bin} 
    #echo $del >>/tmp/aaa.txt
    sleep 5
   done
done

#crontab configure
# 0 3 * * * clear.sh > /dev/null 2>&1