The RENAME syntax is as follows:
RENAME TABLE table_name TO new_table_name [, table_name2 TO new_table_name2,...]
RENAME allows you to give a table (or list of tables) a new name. You can also move a table to a new database by specifying database_name.table_name, as long as the database is on the same disk.
You need the ALTER and DROP permissions on the old table, and the CREATE and INSERT permissions on the new table.