mysql 重命名,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`;