mysql数据库重命名语句分享_Mysql

mysql数据库重命名语句分享

2020-03-01 13:50MYSQL教程网 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`;