各位用户为了找寻关于mysql数据库重命名语句分享的资料费劲了很多周折。这里教程网为您整理了关于mysql数据库重命名语句分享的相关资料，仅供查阅，以下为您介绍关于mysql数据库重命名语句分享的详细内容
代码如下: 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`;