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 求一个sql语句 请问mysql4.0怎么升级为5.1版本呢? 无法打开用 phpMyAdmin 连接数据库 ,在线求助 !!! mysql 密码为空 导入sql脚本问有什么方法比避免回车 咨询一条MYSQL语句的写法 mysql左连接问题 在线求教关于where条件中关于字符串匹配的疑惑 MYSQL怎么会自动停止?? 使用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>