1load data infile 'c:/test.csv'
2into table test [character set utf8]
3fields terminated by ','  optionally enclosed by '"' escaped by '"'
4lines terminated by '\r\n';

1select * from test
2into outfile 'c:/test.csv'
3fields terminated by ',' optionally enclosed by '"' escaped by '"'
4lines terminated by '\r\n';

1select * from (
2	select 'col1','col2','col3','col4' union
3	(select col1,col2,col3,col4 from test where col1 = 'xxx' order by col1)
4) tbl