#!/bin/bash
mysqlconn=" mysql -uroot -paishang132465 "
old_db="aishang"
new_db="aishang_big"
$mysqlconn -e "CREATE DATABASE $new_db"
params=$($mysqlconn -N -e "SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE table_schema='$old_db'")
for name in $params;
do
$mysqlconn -e "RENAME TABLE $old_db.$name to $new_db.$name";
done;
# $mysqlconn -e "DROP DATABASE $old_db"
评论区