mysql 到出到csv 带列表明

select * 
from (
	select 'city_id' as city_id, 'company_id' as company_id, 'contract_no' as contract_no, 'biz_type' as biz_type, 'chargetype_id' as chargetype_id, 'charge_item_no' as charge_item_no, 'settlement_month' as settlement_month, 
	'role_type' as role_type, 'role_user_id' as role_user_id,  'assign_rate' as assign_rate,  'amount' as amount, 'shop_id' as shop_id, 'shop_mgr_id' as shop_mgr_id, 'area_id' as area_id, 'area_mgr_id' as area_mgr_id, 'remark' as remark, 'data_type' as data_type
 UNION ALL
select pd.city_id, pd.company_id, c.contract_no, pd.biz_type, pd.chargetype_id, pd.charge_item_no, pd.settlement_month, 
			pd.role_type, pd.role_user_id, pd.assign_rate, pd.amount, pd.shop_id, pd.shop_mgr_id, pd.area_id, pd.area_mgr_id, pd.remark, pd.data_type
from performance_detail pd
LEFT JOIN contract c
on pd.contract_id=c.id
 ) d 
into outfile '...Desktop/detail.csv'   
fields terminated by ',' optionally enclosed by '"' escaped by '"'   
lines terminated by '\r\n'; ;