mysql select 导出数据 加分隔符，方便生成Excel和利用python进行数据处理。
mysql> select ID,VERSION,HEADLINE from news limit 10 INTO OUTFILE "/tmp/1.txt" fields terminated by ‘|‘;
导入数据
load data local infile ‘test.csv‘ into table test_field fields terminated by ‘,‘ lines terminated by ‘\n‘
原文：http://hunkz.blog.51cto.com/6157447/1951700