MySQL move, rename data table method

MySQL table to move to another DB, table renamed, two table to swap names, etc., How to do?

How to move and rename a Table in MySQL

Commands are all used RENAME can be achieved,

MySQL Table from Db_a to move to Db_b

The code is as follows	Copy Code
RENAME TABLE db_a.old_table to db_b.new_table;

MySQL Table Change name (rename)

The code is as follows	Copy Code
RENAME TABLE old_table to new_table;

MySQL two Table to swap names

code is as follows	copy code
RENAME TABLE old_table to Tmp_table, New_table to Old_table, Tmp_table to new_table;