LOAD DATA导入导出指定列数据

导出数据：

select * from tbl_frn_asp_avb where asp_time >"2013-06-1 00:00:00" and asp_time<="2013-06-30 24:00:00" into  outfile  '/mysqlbak/tbl_asp_avb130601-0630.txt'   fields terminated by ','[(col1,col2,col3,col4....)];

导入数据：

load data local infile '/mysqlbak/tbl_asp_avb130512-0613.txt' into table tbl_frn_asp_avb fields terminated by ',';