in this tutorial, we will learn how to rename the table of MySQL.


Rename Table:

rename table using the following query.

RENAME TABLE old_table TO new_table;


Rename Multiple Tables:

You can rename or alter multiple tables at once using the following query.

RENAME TABLE old_table1 TO new_table1,
             old_table2 TO new_table2,
             old_table3 TO new_table3;


RENAME TABLE, unlike ALTER TABLE, can rename multiple tables within a single statement.