Heim >Datenbank >MySQL-Tutorial >重命名数据库
无详细内容 无 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`;