mysql导入导出部分数据方法

Load Data InFile 'C:/Data.txt' Into Table `TableTest` Lines Terminated By '\r\n';

 select * from cus_customer where id in (20,21,22) into outfile 'e://1.sql’

与mysqldump和souce的区别是，load data infile和select into outfile只操作数据，不对表结构进行修改是dml，不是ddl