您的当前位置:首页 --> MYSQL教程 |
mysql数据库重命名语句分享 |
浏览次数:265 关键词 ( ) |
复制代码 代码如下: 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`; |
下一条 SQL计算timestamp的差值的方法 上一条 mysql建表常用sql语句个人经验分享 |
数千企业与站长的选择,7*24小时稳定运行
了解更多套餐详细