Database name change

If the source database name is "SRCDB", the target database name is "Trgdb"

First create the target database:

Create Database trgdb;

To view all the table names in the source database:

Use INFORMATION_SCHEMA;

Select table_name from TABLES where table_schema= ' srcdb ';

For the table name queried above, execute the following command in turn:

Rename table srcdb.tablename1 to trgdb.tablename1;

In this way, the tables (table structure and table data) in the source database srcdb are all migrated to the target database trgdb.