Table: Rename

RENAME A TABLE

RENAME TABLE old_table TO backup_table; 

 

RENAME MULTIPLE MYSQL TABLES

RENAME TABLE old_table TO backup_table, new_table TO old_table; 


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

 

Cookbook Category: