源码网商城,靠谱的源码在线交易网站 我的订单 购物车 帮助

源码网商城

mysql数据库重命名语句分享

  • 时间:2021-10-18 07:12 编辑: 来源: 阅读:
  • 扫一扫,手机访问
摘要:mysql数据库重命名语句分享
[u]复制代码[/u] 代码如下:
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`;
  • 全部评论(0)
联系客服
客服电话:
400-000-3129
微信版

扫一扫进微信版
返回顶部