将数据库1中的表转移到数据库2中

假设源库名是'song',目标库名是'netctoss_project'

首先创建目标库
create database trgdb;

获取所有源库的表名
use information_schema;
select table_name from TABLES where TABLE_SCHEMA='song';

执行下来之后表就转到新的库里面了.
rename table song.admin_info to netctoss_project.admin_info,
song.admin_role to netctoss_project.admin_role,
song.cost to netctoss_project.cost,
song.emp to netctoss_project.emp,
song.module_info to netctoss_project.module_info,
song.role_info to netctoss_project.role_info,
song.role_module to netctoss_project.role_module,
song.service to netctoss_project.service,
song.service_update_bak to netctoss_project.service_update_bak,
song.t_dept to netctoss_project.t_dept,
song.t_emp to netctoss_project.t_emp,
song.user to netctoss_project.user,
song.users to netctoss_project.users;