How to move and rename a data table in MySQL

This article briefly introduces some common commands for MySQL to move and rename data tables.

What should I do if I want to migrate the MySQL Table to another database, rename the Table, and change the names of the two tables?

How to migrate and rename a Table in MySQL

All commands can be achieved by using RENAME,

MySQL Table to be migrated from db_a to db_ B

The Code is as follows:	Copy code
Rename table db_a.old_table TO db_ B .new_table;

Change MySQL Table name (rename)

The Code is as follows:	Copy code
Rename table old_table TO new_table;

The names of two tables in MySQL must be replaced.

The Code is as follows:	Copy code
Rename table old_table TO tmp_table, New_table TO old_table, Tmp_table TO new_table;