How to rename a table in MySQL

The RENAME TABLE statement can be used to rename an existing table in MYSQL. The following example shows how name of a table changed from tbl_old to tbl_new.

mysql> RENAME TABLE `tbl_old` TO `tbl_new`;
Query OK, 0 rows affected (0.00 sec)
mysql>

LIST TABLES statement can be used to view the list of tables present in a database.