Shell 脚本批量创建数据表 mysql table

shell操作mysql 脚本编写 如下所示，记录备用！！

#!/bin/bash
#execute all script in specified directory

MysqlLogin="mysql -h{host} -u{user} -p{pwd} -P{port} {dbname} --default-character-set=utf8 -e "
echo $MysqlLogin

for ((i=0; i<=1; i++));do
    tablename="log_"$i
    sql="select * from $tablename"   
    
    $MysqlLogin "${sql}"
    
done