Examples for business, study, careers, love, and more...
Examples :: MYSQL Examples :: Example of rename table syntax mysql

Example Of RENAME TABLE Mysql Syntax:




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

CREATE TABLE new_table (...);
RENAME TABLE old_table TO backup_table, new_table TO old_table;

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

RENAME TABLE current_db.tbl_name TO other_db.tbl_name;