A库 yun
B库 testyun
在A库执行 show tables 获取表信息
循环执行!
DROP TABLE IF EXISTS testyun.m_app; //删除B库表 CREATE TABLE testyun.m_app LIKE yun.m_app; //导入A库表结构 Insert INTO testyun.m_app SELECT * from yun.m_app; //导入A库表数据