mysql快速导入导出数据

--导入

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;

 

该语句不含表结构，速度超快