Syntax
------ 
RENAME TABLE tbl_name 
 [WAIT n | NOWAIT]
 TO new_tbl_name
 [, tbl_name2 TO new_tbl_name2] ...
 
Description
----------- 
This statement renames one or more tables or views, but not
the privileges associated to them.
 
The rename operation is done atomically, which means that no
other session can
access any of the tables while the rename is running. For
example, if you have
an existing table old_table, you can create another table
new_table that has the same structure but is empty, and then
replace the existing table with the empty one as follows
(assuming that
backup_table does not already exist):
 
CREATE TABLE new_table (...);
RENAME TABLE old_table TO backup_table, new_table TO
old_table;
 
tbl_name can optionally be specified as db_name.tbl_name.
See Identifier Qualifiers. This allows to use RENAME to move
a table from a database to another (as long as they are on
the same filesystem):
 
RENAME TABLE db1.t TO db2.t;
 
Note that moving a table to another database is not possible
if it has some triggers. Trying to do so produces the
following error:
 
ERROR 1435 (HY000): Trigger in wrong schema
 
Also, views cannot be moved to another database:
 
ERROR 1450 (HY000): Changing schema from 'old_db' to
'new_db' is not allowed.
 
If a RENAME TABLE renames more than one table and one
renaming fails, all renames executed by the same statement
are rolled back.
 
Renames are always executed in the specified order. Knowing
this, it is also possible to swap two tables' names:
 
RENAME TABLE t1 TO tmp_table,
 t2 TO t1,
 tmp_table TO t2;
 
Privileges
 
Executing the RENAME TABLE statement requires the DROP,
CREATE and INSERT privileges for the table or the database.
 
WAIT/NOWAIT
 
Set the lock wait timeout. See WAIT and NOWAIT.
 

 
 
 
 
 
 
 

URL: https://mariadb.com/kb/en/rename-table/