Change a table name
ALTER TABLE old_table RENAME new_table;
Move a table from one database to another
CREATE TABLE new_database_name.new_table_name
LIKE original_database_name.original_table_name;
INSERT new_database_name.new_table_name
SELECT *
FROM original_database_name.original_table_name;