Renaming a table can be done in a single command:
RENAME TABLE `<old name>` TO `<new name>`;
The following syntax does exactly the same:
ALTER TABLE `<old name>` RENAME TO `<new name>`;
If renaming a temporary table, the
ALTER TABLE version of the syntax must be used.
<new name>in the line above with the relevant values. Note: If the table is being moved to a different database, the
tablenamesyntax can be used for