摘要:
下文讲述mysql数据库中对数据表重命名的方法分享,如下所示;
实现思路:
RENAME TABLE databaseName.oldTableName TO databaseName.newTableName;
例:
mysql> use maomao;
Database changed
mysql> show tables;
+----------------------------+
| Tables_in_maomao |
+----------------------------+
| maomao365.com |
+----------------------------+
1 rows in set (0.00 sec)
mysql> rename table maomao.`maomao365.com` to maomao.`maomao365.comB`;
Query OK, 0 rows affected (0.00 sec)
mysql> show tables;
+----------------------------+
| Tables_in_maomao |
+----------------------------+
| maomao365.comB |
| maomao_yarpp_related_cache |
+----------------------------+
1 rows in set (0.00 sec)
mysql> rename table `maomao365.comB` to maomao.`maomao365.comC`;
Query OK, 0 rows affected (0.00 sec)
mysql> show tables;
+----------------------------+
| Tables_in_maomao |
+----------------------------+
| maomao365.comC |
+----------------------------+
1 rows in set (0.00 sec)
最后
以上就是高兴玫瑰最近收集整理的关于mysql 重命名数据库表_mysql 数据库中如何对一个数据表进行重命名呢?的全部内容,更多相关mysql内容请搜索靠谱客的其他文章。
发表评论 取消回复