mysql支持重命名表的操作,采用rename关键字,具体命令格式如下:
alter table 旧表名 rename [to | as] 新表名;
rename table 旧表名 to 新表名;
现在测试一下修改表格名称的命令
---显示当前数据库下面的一个表格,
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| test_ren |
+----------------+
1 row in set (0.00 sec)
mysql> alter table test_ren rename to test_rename;
Query OK, 0 rows affected (0.01 sec)
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| test_rename |
+----------------+
1 row in set (0.00 sec)
mysql> rename table test_rename to test_ren;
Query OK, 0 rows affected (0.01 sec)
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| test_ren |
+----------------+
1 row in set (0.00 sec)