How to Rename MySQL Table?

Question:

MySQL query to rename a table:

RENAME TABLE old_table_name TO new_table_name

Renaming multiple tables using the RENAME command:

RENAME TABLE old_table_name1 TO new_table_name1,
old_table_name2 TO new_table_name2,
old_table_name3 TO new_table_name3;

Another method of renaming table using the ALTER command is:

ALTER TABLE old_table_name RENAME new_table_name