ExportCSVwithHeader

# How to export a mysql table into csv file with header
# the overall ideas in to attach the column names to the select * ....into outfile .. statement 
# (select 'c1','c2','c3') union select c1,c2,c3 from tbl into outfile 'cc.csv'...

# 1st get the column names
select GROUP_CONCAT(CONCAT("'",COLUMN_NAME,"'"))
from INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'my_table'
AND TABLE_SCHEMA = 'my_schema'
order BY ORDINAL_POSITION

# copy the columns' name into the following statement
SELECT 'ColName1', 'ColName2', 'ColName3'
UNION ALL
select * into outfile '<file_name>'
fields terminated by ',' optionally enclosed by '"'
lines terminated by '\n'
from <table_name>;

Reference: http://stackoverflow.com/questions/5941809/include-headers-when-using-select-into-outfile