mysql快速导入导出数据
程序员文章站
2022-06-05 20:53:37
--导入 select * from inhos_genoperation（表名） where UPLOAD_ORG_CODE='***' into outfile '/tmp/inhos_genoperation.sql'; --导出load data infile '/tmp/inhos_gen ......
--导入
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;
该语句不含表结构，速度超快