#!/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"

            <div style="color: inherit; fill: inherit;">
                <div style="display: flex;">