RENAME TABLE allows you to rename multiple tables, which allows you to do things such as swap the names of two tables in a single statement : RENAME « Command MySQL « SQL / MySQL






  1. SQL / MySQL
  2. Command MySQL
  3. RENAME

RENAME TABLE allows you to rename multiple tables, which allows you to do things such as swap the names of two tables in a single statement

       


RENAME TABLE name1 TO temp_name, name2 TO name1, tmp_name to name2;








Related examples in the same category

1.Rename a table is by using the RENAME TABLE statement
2.RENAME TABLE can perform multiple table renaming operations in a single statement.
3.Renaming a Table
4.To rotate log tables to keep a set of daily tables covering the last week
5.Rename a table
6.Rename two tables