重命名语句

RENAME TABLE

RENAME TABLE
    tbl_name TO new_tbl_name
    [, tbl_name2 TO new_tbl_name2] ...

RENAME TABLE old_table TO new_table;

 

ALTER TABLE old_table RENAME new_table;

 

RENAME TABLE old_table1 TO new_table1,
             old_table2 TO new_table2,
             old_table3 TO new_table3;

RENAME TABLE old_table TO tmp_table,
             new_table TO old_table,
             tmp_table TO new_table;