How to rename table in mysql using command line

In this post we will know how to rename table in mysql using command line. It is basic and important command for MySQL database administration. We are doing this practical in MySQL server version 5.5.29.

Syntax:

Replace the table_name and NEW_TABLE_NAME as per your requirement.

ALTER TABLE table_name RENAME NEW_TABLE_NAME

Example: See the below given screenshot

Red Color arrow represents OLD table name
Blue Color arrow represent NEW table name