RENAME TABLE

语句用于对已有表进行重命名。

Query OK, 0 rows affected (0.12 sec)

+----------------+
+----------------+
+----------------+
1 row in set (0.00 sec)

Query OK, 0 rows affected (0.08 sec)

+----------------+
+----------------+
| t2             |
+----------------+
1 row in set (0.00 sec)

• SHOW TABLES