易截截图软件、单文件、免安装、纯绿色、仅160KB

询问 mysql的数据库 库名称如何更改

询问 mysql的数据库 库名称如何更改
(表名是很简单的)
尝试一下变通的方法:

创建一个新的数据库名称

备份要修改的数据库,把备份的数据还原到新建的数据库中

不过这个实时性不好,建议在数据库空闲的时候操作

直接rename 啊


12.1.32. RENAME DATABASE Syntax
RENAME {DATABASE | SCHEMA} db_name TO new_db_name;

This statement was added in MySQL 5.1.7 but was found to be dangerous and was removed in MySQL 5.1.23. It was intended to enable upgrading pre-5.1 databases to use the encoding implemented in 5.1 for mapping database names to database directory names (see Section 8.2.3, “Mapping of Identifiers to File Names”). However, use of this statement could result in loss of database contents, which is why it was removed. Do not use RENAME DATABASE in earlier versions in which it is present.

To perform the task of upgrading database names with the new encoding, use ALTER DATABASE db_name UPGRADE DATA DIRECTORY NAME instead (see Section 12.1.1, “ALTER DATABASE Syntax”).


RENAME TABLE tbl_name TO new_tbl_name
    [, tbl_name2 TO new_tbl_name2] ...



This statement was added in MySQL 5.1.7 but was found to be dangerous and was removed in MySQL 5.1.2

引用
This statement was added in MySQL 5.1.7 but was found to be dangerous and was removed in MySQL 5.1.2



相关问答:

apache+PHP+mysql在win7下使用

如题,这三个在win7下使用会有什么兼容性问题吗?
由于我最近在使用win7,就懒得进xp了!
自己用windows 2008有一年多了,没出现任何问题。

win7测试版也用过,不会有什么问题的,放心。

当然你最 ......

MySQL数据包过大

我用一个循环往数据库里面存文件,本来可以作为文件存放数据库里面只放文件的位置的,但是没有办法租的服务器网页空间大小有限制数据库没有限制。语句是这样的


public static final DataBase.MAXSIZE=102 ......

Winform+MySQL做项目

Winform+MySQL做项目,在注重性能的情况下,我该如何去完成这类型的项目呢!
请各位给以提示。
你这个范围太广了,我说2点重要的吧
1.WINFORM程序是单独运行的CS程序,和BS不同,BS的压力始终都在SERVER上的,对C ......

mysql导入数据库问题

在doc下执行导入命令
  mysql -uadmin -padmin student < d:\a.txt
时提示系统找不到文件,环境变量都设置对了啊,之前也没有出现过这个错误,请大家帮忙解决下!谢了!!
mysql -uadmin -padmin st ......

我要把注册信息提交到mysql中,要怎么办呢?

我在注册页面写入了如下代码:
<?php
    $conn=mysql_connect("localhost","root","614510")or die("数据库服务器连接错误".mysql_error());
& ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号