Syntax:
RENAME TABLE tbl_name TO new_tbl_name
    [, tbl_name2 TO new_tbl_name2] ...

This statement renames one or more tables. 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, a table named old_table can be renamed to new_table as
shown here:

URL: http://dev.mysql.com/doc/refman/5.5/en/rename-table.html

