MySQL 版本信息:
mysql> status;
--------------
mysql Ver 14.14 Distrib 5.7.17, for Win64 (x86_64)
Server version: 5.7.17-log MySQL Community Server (GPL)
--------------
原表名:
mysql> show tables;
+-------------------+
| Tables_in_mybatis |
+-------------------+
| flower |
+-------------------+
1 row in set (0.00 sec)
修改表名:
注:语法“ALTER TABLE 原表名 RENAME TO 新表名;”。
mysql> alter table flower rename to t_flower;
Query OK, 0 rows affected (0.35 sec)
查看修改之后的表名:
mysql> show tables;
+-------------------+
| Tables_in_mybatis |
+-------------------+
| t_flower |
+-------------------+
1 row in set (0.00 sec)