mysql数据库重命名语句分享

2023年 4月 23日 51.1k 0

复制代码 代码如下: 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`.`custo

复制代码 代码如下: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`;

相关文章

Oracle如何使用授予和撤销权限的语法和示例
Awesome Project: 探索 MatrixOrigin 云原生分布式数据库
下载丨66页PDF,云和恩墨技术通讯(2024年7月刊)
社区版oceanbase安装
Oracle 导出CSV工具-sqluldr2
ETL数据集成丨快速将MySQL数据迁移至Doris数据库

发布评论