批量修改mysql表名脚本

#!/bin/bash

table=($(cat ./b.txt))

for ((i=0;i<=${#table[@]};i++))

do

new=$(echo ${table[i]} | sed 's/#mysql50#//g')

mysql -h 127.0.0.1 -P3306   -uroot -p123456  -e "use xwy_log;rename table \`${table[i]}\` to \`${new}\`"

if [[ $? -eq 0 ]];then

echo "The ${table[i]} 表名已修改为 ${new}"

else

echo "The ${table[i]} 表名修改失败"

fi

done

转载于:https://blog.51cto.com/51network/1545647