mysql 批量删除数据库下表

#!/bin/bash 

dbip='192.7.3.5'
dbuser='root'
dbpwds='123456'
dbname='logging'

cat /home/tablenames.txt | while read myline
do
 time=`date +%Y%m%d%H%M%S`
 echo "--start delete $myline--${time}--" >> /home/deltable.log
 delsql="DROP TABLE $myline"
 mysql -h${dbip} -u${dbuser} -p${dbpwds} ${dbname} -e "${delsql}"
 endtime=`date +%Y%m%d%H%M%S` 
 if [ $? -eq 0 ]; then
    echo "--delete $myline success--${endtime}" >> /home/deltable.log
 else
    echo "--delete $myline fail--${endtime}" >> /home/deltable.log
 fi

done

其中tablenames.txt如下：

actionlog_20171130
actionlog_20171201
actionlog_20171202
actionlog_20171203
actionlog_20171204
actionlog_20171205
actionlog_20171206
...