RENAME TABLE

This statement renames an existing table to a new name.

Synopsis

RenameTableStmt

RENAME TABLE - 图1

TableToTable

RENAME TABLE - 图2

  1. RenameTableStmt ::=
  2.     'RENAME' 'TABLE' TableToTable ( ',' TableToTable )*
  4. TableToTable ::=
  5.     TableName 'TO' TableName

Examples

  1. mysql> CREATE TABLE t1 (a int);
  2. Query OK, 0 rows affected (0.12 sec)
  4. mysql> SHOW TABLES;
  5. +----------------+
  6. | Tables_in_test |
  7. +----------------+
  8. | t1             |
  9. +----------------+
  10. 1 row in set (0.00 sec)
  12. mysql> RENAME TABLE t1 TO t2;
  13. Query OK, 0 rows affected (0.08 sec)
  15. mysql> SHOW TABLES;
  16. +----------------+
  17. | Tables_in_test |
  18. +----------------+
  19. | t2             |
  20. +----------------+
  21. 1 row in set (0.00 sec)

MySQL compatibility

The RENAME TABLE statement in TiDB is fully compatible with MySQL. If you find any compatibility differences, report a bug.

See also