How to rename table or Multiple table In MySQL - MySQL Tutorial

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.