How to change the table name in MySQL? | Eklavya Online

How to change the table name in MySQL?

Sometimes our table name is non-meaningful. In that case, we need to change or rename the table name. MySQL provides the following syntax to rename one or more tables in the current database:

mysql> RENAME old_table TO new_table;
If we want to change more than one table name, use the below syntax:

RENAME TABLE old_tab1 TO new_tab1,
old_tab2 TO new_tab2, old_tab3 TO new_tab3;