mysql rename语句_mysql数据库重命名语句分享

代码如下:

CREATE DATABASE `ct` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

RENAME TABLE `51cola`.`commentmeta`

TO `ct`.`commentmeta`;

RENAME TABLE `51cola`.`comments`

TO `ct`.`comments`;

RENAME TABLE `51cola`.`customcontactforms_fields`

TO `ct`.`customcontactforms_fields`;

RENAME TABLE `51cola`.`customcontactforms_field_options`

TO `ct`.`customcontactforms_field_options`;

RENAME TABLE `51cola`.`customcontactforms_forms`

TO `ct`.`customcontactforms_forms`;

RENAME TABLE `51cola`.`customcontactforms_styles`

TO `ct`.`customcontactforms_styles`;

RENAME TABLE `51cola`.`customcontactforms_user_data`

TO `ct`.`customcontactforms_user_data`;

RENAME TABLE `51cola`.`links`

TO `ct`.`links`;

RENAME TABLE `51cola`.`options`

TO `ct`.`options`;

RENAME TABLE `51cola`.`postmeta`

TO `ct`.`postmeta`;

RENAME TABLE `51cola`.`posts`

TO `ct`.`posts`;

RENAME TABLE `51cola`.`terms`

TO `ct`.`terms`;

RENAME TABLE `51cola`.`term_relationships`

TO `ct`.`term_relationships`;

RENAME TABLE `51cola`.`term_taxonomy`

TO `ct`.`term_taxonomy`;

RENAME TABLE `51cola`.`usermeta`

TO `ct`.`usermeta`;

RENAME TABLE `51cola`.`users`

TO `ct`.`users`;

DROP DATABASE `51cola`;

您可能感兴趣的文章:MySQL 修改数据库名称的一个新奇方法

安全快速修改Mysql数据库名的5种方法

MySQL数据库命名规范及约定

MYSQL 数据库命名与设计规范

Mysql数据库名和表名在不同系统下的大小写敏感问题

MySQL创建带特殊字符的数据库名称方法示例