MySQL – Rename Table 

Two methods are available for renaming tables in MySQL. 

1.In the first case, the ALTER TABLE syntax is used:

Syntax:

ALTER TABLE old_table_name RENAME new_table_name;

Example:

ALTER TABLE employees
  RENAME TO staff;

2.A second method is to use RENAME TABLE:

Syntax:

RENAME TABLE old_table_name TO new_table_name;

Example:

RENAME TABLE employees TO staff;