my sql给表重命名 my sql中rename rename to都可以给表重命名还有一个rename oldtablename to newtablename我想知道这种格式写一个完整的重命名多谢各位 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 mysql> use testDatabase changedmysql> show tables;+----------------+| Tables_in_test |+----------------+| by_month | | by_year | | http_auth | | order_test | | show_users | | song_batch | | t11 | | t11_replicas | | test_hour | +----------------+9 rows in set (0.00 sec)mysql> rename table t11 to t11_new;Query OK, 0 rows affected (0.05 sec)mysql> show tables;+----------------+| Tables_in_test |+----------------+| by_month | | by_year | | http_auth | | order_test | | show_users | | song_batch | | t11_new | | t11_replicas | | test_hour | +----------------+9 rows in set (0.00 sec)mysql> rename table t11_new to t11;Query OK, 0 rows affected (0.01 sec)mysql> show tables;+----------------+| Tables_in_test |+----------------+| by_month | | by_year | | http_auth | | order_test | | show_users | | song_batch | | t11 | | t11_replicas | | test_hour | +----------------+9 rows in set (0.00 sec)mysql> EXEC SP_RENAME '原名','修改后的名称' mysql root权限问题 MYSQL的基本操作如何实现 MySql 备份还原 在线等 !!!!! 如何对mysql数据库改名? 请教各位一个 MYSQL 存储过程 问个MYSQL问题 错误:Data truncated for column 's' at row 1 MYSQL的请求服务数量 如何根据一组ID查询并增加一列显示名称 请问你的PHP是应用在WIN平台还是UNIX平台,MYSQL在WIN平台上不是要付费的吗? 关于索引 使用PD,MSSQL转换mysql数据库的问题 数据库空字段问题
mysql> use test
Database changed
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| by_month |
| by_year |
| http_auth |
| order_test |
| show_users |
| song_batch |
| t11 |
| t11_replicas |
| test_hour |
+----------------+
9 rows in set (0.00 sec)mysql> rename table t11 to t11_new;
Query OK, 0 rows affected (0.05 sec)mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| by_month |
| by_year |
| http_auth |
| order_test |
| show_users |
| song_batch |
| t11_new |
| t11_replicas |
| test_hour |
+----------------+
9 rows in set (0.00 sec)mysql> rename table t11_new to t11;
Query OK, 0 rows affected (0.01 sec)mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| by_month |
| by_year |
| http_auth |
| order_test |
| show_users |
| song_batch |
| t11 |
| t11_replicas |
| test_hour |
+----------------+
9 rows in set (0.00 sec)mysql>