导出mysql表的部分记录

导出：

select * from db.tab1 where id=xxx  into outfile '/tmp/row.txt' fields terminated by '|' enclosed by ''; 

导入：

load data local infile '/root/row.txt'' into table tab1 fields terminated by '|' enclosed by '';

版权声明：QQ:597507041