MySQL table rename

You can rename any table using the rename sql command.
Please note that previously present data will NOT be lost

Sintax

RENAME TABLE [old_database.]old_table TO [new_database.]new_table;

As described, the origin and destination database name are optional; they should be included only when you want to move the table between two databases. If you would just rename the table, and thus wouldn't need to move in another database, the command will be:

RENAME TABLE old_table TO new_table;

Example
If you want to move the "customers" table to another database, here's the code:

RENAME TABLE project.customers TO project2.customers2;

If you only want to rename the same table from "customers" to "customers2" instead here is the solution:

RENAME TABLE customers TO customers2;