RENAME TABLE can perform multiple table renaming operations in a single statement. : RENAME « Command MySQL « SQL / MySQL






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

RENAME TABLE can perform multiple table renaming operations in a single statement.

      

RENAME TABLE t1 TO tmp, t2 TO t1, tmp TO t2;








Related examples in the same category

1.Rename a table is by using the RENAME TABLE statement
2.Renaming a Table
3.To rotate log tables to keep a set of daily tables covering the last week
4.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
5.Rename a table
6.Rename two tables