整理了一些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`.`customcont

技术
今日推荐
下载桌面版
GitHub
百度网盘(提取码:draw)
Gitee
云服务器优惠
阿里云优惠券
腾讯云优惠券
华为云优惠券
站点信息
问题反馈
邮箱:[email protected]
QQ群:766591547
关注微信