Renaming a Table in MySQL

Here are 2 different ways to do this: 

mysql> create table old_name

    -> (col1 varchar(5));

Query OK, 0 rows affected (0.03 sec)

 

mysql> alter table old_name

    -> rename to new_name;

Query OK, 0 rows affected (0.01 sec)

 

mysql> rename table new_name to old_name;

Query OK, 0 rows affected (0.00 sec)

 

mysql>