Home >Database >Mysql Tutorial >重命名数据库

重命名数据库

WBOY
WBOYOriginal
2016-06-07 14:57:12975browse

无详细内容 无 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

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`;
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn