--导入
select * from inhos_genoperation(表名) where UPLOAD_ORG_CODE='***' into outfile '/tmp/inhos_genoperation.sql';
--导出
load data infile '/tmp/inhos_genoperation.sql' into table qingtongxiayiyuan.inhos_genoperation;
该语句不含表结构,速度超快
--导入
select * from inhos_genoperation(表名) where UPLOAD_ORG_CODE='***' into outfile '/tmp/inhos_genoperation.sql';
--导出
load data infile '/tmp/inhos_genoperation.sql' into table qingtongxiayiyuan.inhos_genoperation;
该语句不含表结构,速度超快
转载于:https://www.cnblogs.com/lingxiao102/p/9764749.html