RENAME TABLE

更改表的名称。

句法

ALTER TABLE [ IF EXISTS ] <name> RENAME TO <new_table_name>

示例

CREATE TABLE test(a INT);

SHOW TABLES;
+------+
| name |
+------+
| test |
+------+

ALTER TABLE `test` RENAME TO `new_test`;

SHOW TABLES;
+----------+
| name     |
+----------+
| new_test |
+----------+